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

RMAN-05501: aborting duplication of target database

1 Answers  


TNS-12686: Invalid command specified for a service

1 Answers  


RMAN-06425: <datafile pathname not available>

1 Answers  


PLS-00407: '*' not allowed here; a list of columns is required

1 Answers  


ORA-00384: Insufficient memory to grow cache

1 Answers  


DRG-13007: cannot define an alternate value for the DEFAULT sub lexer

1 Answers  


ORA-30189: reserved for future use

1 Answers  


ORA-09884: Two Task interface: SID doens't match current PU

1 Answers  


ORA-03204: the segment type specification should indicate partitioning

1 Answers  


NZE-28790: NLS string open failure

1 Answers  


ORA-14603: [SUBPARTITIONS | SUBPARTITION TEMPLATE] subpartition_count syntax is valid only for range-hash tables

1 Answers  


ORA-00020: maximum number of processes (string) exceeded

2 Answers  


Categories