Oracle Solution for Error ora-19728

ORA-19728: data object number conflict between table string and partition string in table string

What triggered the Error:

e non-partitioned table has the same data object number as one of the partitions in the partitioned table. One can not exchange the table with the partition in this case.

What should we do to fix it:

e "alter table move partition" command to move the offending partition, so that the partition will get a new data object number. Retry the operation then.