Interested to Buy Any Domain ? << Click Here >> for more details...
ORA-14130: UNIQUE constraints mismatch in ALTER TABLE
EXCHANGE PARTITION
- 1 Answers
- 7955 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 |
TNS-04007: Internal error number.
PCC-00011: Already in a declare section at line number in file string
ORA-22344: can not specify CONVERT TO SUBSTITUTABLE option for ALTER TYPE other than NOT FINAL change
PCC-00053: FOR variable string is invalid type at line number in file string
TNS-01169: The listener has not recognized the password
ORA-23373: object group "string"."string" does not exist
NNL-00410: Average response time: string
ORA-30515: suspend triggers cannot have BEFORE type
ORA-38710: Flashback log version string is incompatible with ORACLE version string.
NZE-28773: failure to write magic and version numbers
ORA-23383: registration for materialized view repgroup "string"."string" failed at site string
DRG-52101: an invalid session handle was passed to Oracle Text
Oracle Errors 
