ORA-54605: CREATE_PC: scratch-tables/views (string) exist and need to be dropped ORACLE 报错 故障修复 远程处理

文档解释

ORA-54605: CREATE_PC: scratch-tables/views (string) exist and need to be dropped

Cause: Transient tables/views from a previous CREATE_PC operation were still in existence.

Action: Delete the invalid Point Cloud from the base table (for cleanup of scratch tables), and initialize and create the Point Cloud again. Alternately, use SDO_UTIL.DROP_WORK_TABLES with oidstring as the parameter.

ORA-54605是由于您正在执行CREATE_PC操作时发现已存在的scratch-tables/views而导致的行为。这个错误旨在提醒用户在执行CREATE_PC操作之前需要删除现有的scratch-tables/views。

官方解析：该错误表明要执行的操作类型需要删除现有的 “ scratch-tables/views ” 。

常见案例

一般处理方法及步骤

1.使用下面的SQL查找当前存在的scratch-tables/views：

SELECT *

FROM USER_VIEWS

WHERE UPPER(VIEW_NAME) LIKE ‘SCRATCH_%’;

2.准备删除scratch-tables/views，使用下面语句：

DROP VIEW view_name;

3.最后重新执行 CREATE_PC 操作。