Oracle Solution for Error ora-39228

Solution for Oracle Error ORA-39228

ORA-39228: Unable to construct a unique departitioned object name for string string


:string when defaulted.

What triggered the Error:

All (sub)partitions in the job were to be created as individual objects and the renaming was defaulted. The job will attempt to create unique object names, but the name creation algorithm was unable to find a unique object name for the specified (sub)partition.

What should we do to fix it:

Specify a rename_table transform to use or delete some of the existing objects causing the name conflicts.