ORA-14130: UNIQUE constraints mismatch in ALTER TABLE
EXCHANGE PARTITION
- 1 Answers
- 7540 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-01873: the leading precision of the interval is too small
ORA-33263: Could not create analytic workspace string
DRG-50865: failed to append to collection
ORA-33918: (MAKEDCL33) You cannot define a surrogate of dimension workspace object because it is a string.
ORA-25442: too many column values for table alias: string
ORA-27412: repeat interval contains invalid keyword: string
ORA-01283: Options specified is invalid
ORA-01158: database string already mounted
ORA-38406: attribute set string already exists
ORA-01695: error converting rollback segment string to version 8.0.2
ORA-12418: user string not found
PLS-00597: expression 'string' in the INTO list is of wrong type
Oracle Errors 
