ORA-13123: invalid name specified ORACLE 报错 故障修复 远程处理

文档解释

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。