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-14260: incorrect physical attribute specified for this partition

1 Answers  


RMAN-06744: specification does not match any datafilecopy in the repository

1 Answers  


DRG-10573: index string is obsolete

1 Answers  


ORA-24902: invalid subscription name or name-length in subscription handle

1 Answers  


NNO-00301: server will shut down in number seconds

1 Answers  






ORA-01310: requested return type not supported by the lcr_mine function

1 Answers  


ORA-31006: Path name segment length string exceeds maximum length string

1 Answers  


ORA-01033: ORACLE initialization or shutdown in progress

2 Answers  


PCB-00011: DBMS=V6 no longer supported; using DBMS=NATIVE

1 Answers  


ORA-02229: invalid SIZE option value

1 Answers  


QSM-02064: subquery in mv

1 Answers  


ORA-01866: the datetime class is invalid

3 Answers  


Categories