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

NNL-00345: Save_config_on_stop is currently OFF

1 Answers  


ORA-19504: failed to create file "string"

1 Answers  


PCC-00099: Length cannot be given for types ROWID, DATE, or MLSLABEL

1 Answers  


ORA-15113: alias name 'string' refers to a directory

1 Answers  


ORA-14629: cannot drop the only subpartition of a partition

1 Answers  






ORA-16548: object not enabled

1 Answers  


NNO-00112: line string: ignored duplicate data of type "string"

1 Answers  


RMAN-06442: enter UPGRADE CATALOG command again to confirm catalog upgrade

1 Answers  


QSM-01092: mjv tries to rewrite a semi-join and primary key or rowid missing

1 Answers  


SQL*Loader-00945: record size number too large for direct path

1 Answers  


NNC-00405: network failure

1 Answers  


PLS-00328: A subprogram body must be defined for the forward declaration of string.

1 Answers  


Categories