Oracle Error ORA-54641: PARTITION_TABLE utility: scratch tables exist with oidstr = string

Oracle Error Message

ORA-54641: PARTITION_TABLE utility: scratch tables exist with oidstr = string

Reason for the Error

Scratch tables/views could not be created because they already existed.

Solution

Use SDO_UTIL.DROP_WORK_TABLES with the specified oidstr parameter to clean up the scratch tables.