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-32812: subscriber string does not exist

1 Answers  


ORA-37082: Invalid percent

1 Answers  


ORA-09853: snyRemovePort: bad return code from request.

1 Answers  


ORA-28177: incorrect Kerberos ticket version

1 Answers  


TNS-04235: Trace Assistant WARNING: Unknown TTC protocol

1 Answers  


NPL-00418: received malformed ASN.1 object identifier

1 Answers  


ORA-12087: online redefinition not allowed on tables owned by "string"

1 Answers  


ORA-06136: NETTCP: error during connection handshake

1 Answers  


ORA-31448: invalid value for change_source

1 Answers  


ORA-06303: IPA: Message send error

1 Answers  


ORA-16212: number processes specified for APPLY is too great

1 Answers  


LSX-00244: invalid NCName "~S"

1 Answers  


Categories