How to fix the Oracle error ORA-54605: CREATE_PC: scratch-tables/views (string) exist and need to be dropped?

In this post, you’ll learn more about the Oracle ErrorORA-54605: CREATE_PC: scratch-tables/views (string) exist and need to be dropped with the details on why you receive this error and the possible solution to fix it.

Oracle Error Description

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

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

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

How to fix the Error ORA-54605: CREATE_PC: scratch-tables/views (string) exist and need to be dropped ?

You can fix this error in Oracle by following the below steps

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.