Oracle Solution for Error ora-54655

ORA-54655: CREATE_TIN: scratch tables/views(string

) exist and need to be dropped

What triggered the Error:

Transient tables from previous CREATE_TIN operation still existed.

What should we do to fix it:

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