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

In this post, you’ll learn more about the Oracle ErrorORA-54655: CREATE_TIN: 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-54655: CREATE_TIN: scratch tables/views(string) exist and need to be dropped

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

Transient tables from previous CREATE_TIN operation still existed.

How to fix the Error ORA-54655: CREATE_TIN: 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 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.