Interested to Buy Any Domain ? << Click Here >> for more details...
ORA-14130: UNIQUE constraints mismatch in ALTER TABLE
EXCHANGE PARTITION
- 1 Answers
- 8131 Views
- I also Faced
- E-Mail Answers
Answer / guest
Cause: One of the tables named in the ALTER TABLE EXCHANGE
PARTITION command has a UNIQUE constraint for which no
matching (vis-a-vis key columns) constraint is defined on
the other table or a matching constraint is defined on the
other table, but it differs from that defined on the first
table vis-a-vis being enabled and/or validated.
Action: Ensure that for every UNIQUE constraint defined on
one of the tables named in the ALTER TABLE EXCHANGE
PARTITION statement there is a matching (vis-a-vis key
columns and being enabled and/or validated) UNIQUE
constraint defined on the other table. If UNIQUE constrains
are enabled, UNIQUE constraints on the partitioned table
should be enforced using local indexes.
Please add more information about this Error
| Is This Answer Correct ? | 1 Yes | 0 No |
ORA-16040: standby destination archive log file is locked
TNS-12542: TNS:address already in use
ORA-28300: No permission to read user entry in LDAP directory service.
ORA-12496: cannot change existing level, category, or release numbers
ORA-22167: given trim size [string] must be less than or equal to [string]
TNS-02509: Authentication: invalid process state
ORA-30156: Out of disk space
PCC-02045: CMD-LINE: Option is not unique:
DRG-11618: URL store: document identified by string is too large
ORA-16039: RFS request version mismatch
ORA-14316: table is not partitioned by List method
ORA-00314: log string of thread string, expected sequence# string doesn't match string
Oracle Errors 
