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

KUP-11010: unable to open at least one dump file for load

1 Answers  


ORA-36691: (NTEXTCNV02) Invalid escape sequence in argument to UNISTR function: string.

1 Answers  


ORA-09360: Windows 3.1 Two-Task driver unable to allocate context area

1 Answers  


IMP-00069: Could not convert to environment national character set's handle

1 Answers  


ORA-28560: error in configuration of agent process

1 Answers  


ORA-36212: (XSAGOP06) In AGGMAP workspace object, you can only specify the MIN, MAX, FLOOR, and CEILING arguments while using the PROPORTIONAL operator, not string.

1 Answers  


KUP-04068: internal error fetching attribute string

1 Answers  


SQL*Loader-00294: invalid name % specified in TREAT AS clause

1 Answers  


IMG-00510: %s

1 Answers  


RMAN-04008: WARNING from target database: string

1 Answers  


ORA-08102: index key not found, obj# string, file string, block string (string)

1 Answers  


PCB-00314: DECLARE DATABASE is an Oracle extension

1 Answers  


Categories