ORA-13123: invalid name specified

文档解释

ORA-13123: invalid name specified

Cause: The create_topo operation requires a unique TOPOLOGY name, that already does not exist in the database.

Action: Check to see if there is already an entry in the USER_SDO_TOPO_METADATA (or the MDSYS.SDO_TOPO_METADATA_TABLE) with this topology name.

ORA-13123错误是指在提供给地理空间服务工具包(SDO_UTIL)某些处理过程函数时,使用了一个无效的TOPOLOGY名称。

官方解释

Cause:A topology with this name was not found. This topology must have been created with SDO_TOPO.CREATE_TOPOLOGY before the function invocation.

Action:Make sure an appropriate topology was created and the name used with the function is correct.

常见案例

正常处理方法及步骤

1.检查TOPOLOGY的名字是否给出,是否符合格式规范,如不符合,则重新指定一个合法的TOPOLOGY名称;

2.检查TOPOLOGY是否存在,使用SELECT TOPOLOGY_NAME FROM MDSYS.SDO_TOPOLOGIES;命令来查看是否有对应名字的TOPOLOGY;

3.如果TOPOLOGY不存在,则需要先用SDO_TOPO.CREATE_TOPOLOGY来创建TOPOLOGY。

你可能感兴趣的