Oracle Error ORA-54655: CREATE_TIN: scratch tables/views(string) exist and need to be dropped

Oracle Error Message

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

Reason for the Error

Transient tables from previous CREATE_TIN operation still existed.

Solution

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.