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-14130: UNIQUE constraints mismatch in ALTER TABLE
EXCHANGE PARTITION



ORA-14130: UNIQUE constraints mismatch in ALTER TABLE EXCHANGE PARTITION..

Answer / guest

Cause: One of the tables named in the ALTER TABLE EXCHANGE
PARTITION 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
PARTITION 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 ?    1 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

NID-00390: These files must be writable by this utility.

1 Answers  


ORA-34276: (MXDCL33) (Precision, Scale) arguments can only be used with a NUMBER variable or dimension.

1 Answers  


ORA-36910: (XSAGDNGL47) In AGGMAP workspace object, DYNAMIC MODEL workspace object can only edit the top level of its matching relation hierarchy.

1 Answers  


ORA-13444: GeoRaster metadata SRS error

1 Answers  


NNO-00160: warning: ignoring duplicate hint server "string"

1 Answers  


ORA-24344: success with compilation error

1 Answers  


ORA-13516: SWRF Operation failed: string

1 Answers  


ORA-25216: invalid recipient, either NAME or ADDRESS must be specified

1 Answers  


IMP-00019: row rejected due to ORACLE error number

1 Answers  


CLSR-00502: Error number encountered when subscribing an EVM event

1 Answers  


ORA-38752: file string does not exist

1 Answers  


ORA-07346: slnrm: normalized file name is too long

1 Answers  


Categories