ORA-14130: UNIQUE constraints mismatch in ALTER TABLE
EXCHANGE PARTITION
- 1 Answers
- 8196 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 |
RMAN-04021: target database DBID string does not match channel's DBID string
ORA-01657: invalid SHRINK option value
DRG-10503: table string cannot be indexed because it has no primary key
QSM-02026: non-AND conjunction in WHERE clause
ORA-09883: Two Task interface: oratab file does not exist
NID-00508: HELP Displays these messages NO
NCR-01010: NCRS: Invalid network address length.
RMAN-10031: RPC Error: ORA-number occurred during call to string.string
ORA-19570: file number string is outside valid range of 1 through string
ORA-19018: Invalid character in XML tag 'string'
RMAN-08000: channel string: copied datafile string
DRG-50934: parser hash create failure
Oracle Errors 
