Interested to Buy Any Domain ? << Click Here >> for more details...
ORA-14283: UNIQUE constraints mismatch in ALTER TABLE
EXCHANGE SUBPARTITION
- 1 Answers
- 4867 Views
- I also Faced
- E-Mail Answers
Answer / guest
Cause: One of the tables named in the ALTER TABLE EXCHANGE
SUBPARTITION 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
SUBPARTITION 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 ? | 0 Yes | 0 No |
ORA-31222: DBMS_LDAP: PL/SQL - Invalid LDAP SSL authentication mode.
NNO-00800: Error: cannot read version from config database
ORA-01633: Real Application Clusters Option needed for this operation
ORA-19642: incremental-start SCN is string
ORA-29902: error in executing ODCIIndexStart() routine
ORA-19684: block media recovery failed because database is suspended
NNO-00152: warning: hint count number exceeds maximum of number, first number will be loaded
ORA-02037: uninitialized speed bind storage
ORA-01490: invalid ANALYZE command
RMAN-08056: skipping datafile string because it has not changed
ORA-02753: osnfsmmap: cannot close shared memory file
ORA-39094: Parallel execution not supported in this database edition.
Oracle Errors 
