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-09712: orasrv: log archiver already connected.

1 Answers  


ORA-25405: transaction status unknown

1 Answers  


LPX-00263: couldn't connect to host ~s port ~d

1 Answers  


Recent I have migrated oracle9i to oracle10g(10.2.0.3). I have nested table that table used user define datatype. at a column. when i want to input the valoue at this column ,i cann't the input value.following the error messasge i have got: ORA-24328 illegal attribute value

1 Answers  


ORA-12544: TNS:contexts have different wait/test functions

1 Answers  






LPX-00205: expected "

1 Answers  


NZE-29118: Cannot create PKCS #12 attributes.

1 Answers  


RMAN-00557: could not open MSGLOG "string"

1 Answers  


DRG-12211: section or section id string does not exist

1 Answers  


ORA-10614: Operation not allowed on this segment

1 Answers  


ORA-12640: Authentication adapter initialization failed

1 Answers  


ORA-07339: spcre: maximum number of semaphore sets exceeded.

1 Answers  


Categories