Friday, 6 April 2012

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

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 can not exchange the table with the partition in this case.

Action: Use 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.

No comments:

Post a Comment