Interested to Buy Any Domain ? << Click Here >> for more details...
ORA-14283: UNIQUE constraints mismatch in ALTER TABLE
EXCHANGE SUBPARTITION
- 1 Answers
- 4834 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 |
TNS-02518: key negotiation error
ORA-06033: NETDNT: connect failed, partner rejected connection
ORA-14552: cannot perform a DDL, commit or rollback inside a query or DML
DRG-11878: Loading New Rules Must Be Explicitly Acknowledged
PLS-00153: A string type may only be used as an object type attribute.
TNS-00549: value specified for the SSL version is not valid
LSX-00123: base type is required
EXP-00042: Missing NLS_CHARACTERSET/NLS_NCHAR_CHARACTERSET in props$
ORA-16184: DB_UNIQUE_NAME string hashes to the same value as DB_UNIQUE_NAME string
PCC-00109: Dynamic SQL and PL/SQL are Oracle extensions to ANSI SQL
ORA-13447: GeoRaster metadata BRS error
ORA-30189: reserved for future use
Oracle Errors 
