Oracle Solution for Error ora-54605

Solution for Oracle Error ORA-54605

ORA-54605: CREATE_PC: scratch-tables/views (string

) exist and need to be dropped

What triggered the Error:

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

What should we do to fix it:

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.