文档解释
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 操作。
