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..

Answer / guest

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.

Please add more information about this Error

Is This Answer Correct ?    1 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

ORA-30929: ORDER SIBLINGS BY clause not allowed here

1 Answers  


ORA-09812: Unable to get user clearance from connection

1 Answers  


ORA-22914: DROP of nested tables not supported

1 Answers  


NNL-00263: Request forwarding is now enabled

1 Answers  


RMAN-08157: script string written to file string

1 Answers  






ORA-28583: remote references are not permitted during agent callbacks

1 Answers  


ORA-02736: osnfpm: illegal default shared memory address

1 Answers  


ORA-24306: bad buffer for piece

1 Answers  


ORA-24405: error occured while trying to create connections in the pool

1 Answers  


RMAN-03014: implicit resync of recovery catalog failed

1 Answers  


ORA-29517: recursive resolution failed for a referenced class

1 Answers  


LSX-00122: value is not valid restriction of parent's whiteSpace

1 Answers  


Categories