Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...


ORA-14283: UNIQUE constraints mismatch in ALTER TABLE
EXCHANGE SUBPARTITION



ORA-14283: UNIQUE constraints mismatch in ALTER TABLE EXCHANGE SUBPARTITION..

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

Post New Answer

More Oracle Errors Interview Questions

DRG-11711: too much data for term string

1 Answers  


NNL-00346: Save_config_on_stop is now ON

1 Answers  


ORA-01870: the intervals or datetimes are not mutually comparable

1 Answers  


PROC-00030: Oracle Cluster Registry IDs do not match

1 Answers  


ORA-30690: timeout occurred while registering a TCP/IP connection for data traffic detection

1 Answers  


ORA-28651: Primary index on IOTs can not be marked unusable

1 Answers  


ORA-13782: The specified user "string" does not exist.

1 Answers  


NZE-28822: Required seed is not specified.

1 Answers  


ORA-12155: TNS:received bad datatype in NSWMARKER packet

1 Answers   IBM,


UDE-00016: 'string' parameter requires a value.

1 Answers  


ORA-06532: Subscript outside of limit

1 Answers  


when i ran any workflow or session, getting below error: seesion task instance[s_xxx]: Execution terminated unexpecterdly

0 Answers  


Categories