Interested to Buy Any Domain ? << Click Here >> for more details...
ORA-14283: UNIQUE constraints mismatch in ALTER TABLE
EXCHANGE SUBPARTITION
- 1 Answers
- 4779 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-22913: must specify table name for nested table column or attribute
ORA-00096: invalid value string for parameter string, must be from among string
ORA-16022: LOG_ARCHIVE_DEST cannot be NULL because LOG_ARCHIVE_DUPLEX_DEST is non-NULL
CLSR-01003: Error number encountered during mounting database
IMG-00844: internal image data allocation failed
RMAN-06113: changed archive log available
NNO-00809: Unknown OCI error: number
NNL-00992: Auto-refresh failure retry interval: string
ORA-02285: duplicate START WITH specifications
AMD-00102: invalid metadata entity: string "string"
TNS-00315: Failed to allocate larger connect data area for getting pump data: number
RMAN-06477: configuration value length exceeds 1024
Oracle Errors 
