Interested to Buy Any Domain ? << Click Here >> for more details...
ORA-14130: UNIQUE constraints mismatch in ALTER TABLE
EXCHANGE PARTITION
- 1 Answers
- 8118 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 |
PLS-00639: NCHAR/NVARCHAR2 cannot be byte length semantics
ORA-12649: Unknown encryption or data integrity algorithm
EXP-00037: Export views not compatible with database version
ORA-25132: UNIQUE constraint (string.string) disabled and validated in ALTER TABLE EXCHANGE PARTITION
ORA-30466: can not find the specified workload string
TNS-00252: Unable to handle route request: string
ORA-30346: hierarchy name must be unique within a dimension
ORA-16060: Log file is current
DRG-10754: memory size must be between string and string
ORA-00079: variable string not found
ORA-27546: Oracle compiled against IPC interface version string.string found version string.string
PCC-02404: This indicator variable must be declared as a pointer type
Oracle Errors 
