ORA-14283: UNIQUE constraints mismatch in ALTER TABLE
EXCHANGE SUBPARTITION
- 1 Answers
- 4233 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-01630: max # extents (string) reached in temp segment in tablespace string
ORA-01049: Bind by name is not spupportted in streamed RPC
ORA-29915: cannot select FOR UPDATE from collection operand
ORA-12800: system appears too busy for parallel query execution
PLW-07202: bind type would result in conversion away from column type
PLS-00712: illegal option for subprogram string
AMD-00152: Workspace "string" is not currently open.
TNS-01079: Attempted to bequeath: string
DRG-12003: Please enter username for this FTP server:
ORA-06970: X.25 Driver: remote host is unknown
RMAN-06606: RMAN configuration parameters are successfully reset to default value
RMAN-03012: fatal error during compilation of command
Oracle Errors 
