Interested to Buy Any Domain ? << Click Here >> for more details...
ORA-14283: UNIQUE constraints mismatch in ALTER TABLE
EXCHANGE SUBPARTITION
- 1 Answers
- 4752 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-33443: (ESDREAD14) Discarding compiled code for workspace object because analytic workspace string is not attached.
ORA-27473: argument string does not exist
ORA-04017: invalid value string (length = string) for parameter max_dump_file_size
ORA-19802: cannot use DB_RECOVERY_FILE_DEST without DB_RECOVERY_FILE_DEST_SIZE
DRG-50607: failed to obtain column info for cid string
NNL-01076: Operational Status number
RMAN-06025: no backup of log thread number seq number lowscn string found to restore
ORA-13195: failed to generate maximum tile value
ORA-28561: unable to set date format on non-Oracle system
ORA-09742: sppst: error during a post.
ORA-00390: log string of thread string is being cleared, cannot become current log
ORA-02271: table does not have such constraint
Oracle Errors 
