Interested to Buy Any Domain ? << Click Here >> for more details...
ORA-14290: PRIMARY KEY constraint mismatch in ALTER TABLE
EXCHANGE [SUB]PARTITION
- 1 Answers
- 2723 Views
- I also Faced
- E-Mail Answers
Answer / guest
Cause: The corresponding columns in the tables specified in
the ALTER TABLE EXCHANGE [SUB]PARTITION statement have
different PRIMARY KEY constraints.
Action: Ensure that the two tables do not have PRIMARY KEY
constraints defined on any column or disable all PRIMARY KEY
constraints on both tables. Then retry the operation.
Please add more information about this Error
| Is This Answer Correct ? | 0 Yes | 0 No |
ORA-02404: specified plan table not found
ORA-01300: writable database required for specified LogMiner options
RMAN-06074: file string is not an ORACLE datafile
DRG-11605: URL store: document specified by string not found
ORA-02286: no options specified for ALTER SEQUENCE
IMG-00703: unable to read image data
ORA-08115: can not online create/rebuild this index type
ORA-01699: tablespace 'string' is being imported for point in time recovery
ORA-19691: %s is from different database: id=string, name=string
NCR-03005: NCRO: Orphan message
SQL*Loader-00409: Number to skip must be table-level, not load-level on continued loads
ORA-24016: cannot create QUEUE_TABLE, user string does not have execute privileges on QUEUE_PAYLOAD_TYPE string.string
Oracle Errors 
