The following is the ORA-19728 error message, you can learn the cause and solution of the Oracle database error.


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

Cause: The non-partitioned table has the same data object number as one of the partitions in the partitioned table. One cannot exchange the table with the partition in this case.

Solution: Use the 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.

Case:

Please wait for the update…