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

PCC-01003: Invalid continuation at line number in file string

1 Answers  


NNO-00803: Error: OCI_INVALID_HANDLE

1 Answers  


PCB-00578: Variable "string" must be a table

1 Answers  


RMAN-06180: incremental backups require Enterprise Edition

1 Answers  


LFI-00146: copy does not expect the file string.string to exist

1 Answers  






TNS-01081: Started with pid=string

1 Answers  


ORA-01494: invalid SIZE specified

1 Answers  


TNS-00310: Navigator: Failed to start tracing after rereading parameter data

1 Answers  


ORA-29275: partial multibyte character

1 Answers  


ORA-16053: DB_UNIQUE_NAME string is not in the Data Guard Configuration

1 Answers  


RMAN-06453: RECOVERABLE may only be used with datafile objects

1 Answers  


DRG-50803: failed to define output

1 Answers  


Categories