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

ORA-31212: DBMS_LDAP: PL/SQL - Invalid LDAP mod_array.

1 Answers  


PLS-00168: duplicate modifier specification 'string'

1 Answers  


ORA-13276: internal error [string] in coordinate transformation

1 Answers  


ORA-19715: invalid format string for generated name

1 Answers  


ORA-02304: invalid object identifier literal

1 Answers  


RMAN-06487: changed proxy copy expired

1 Answers  


NNF-04005: Cannot open inputfile

1 Answers  


QSM-02134: agg(expr) requires correspondng MAX(expr) function

1 Answers  


NID-00331: The following datafiles are disabled:

1 Answers  


RMAN-06030: the DELETE [ALL] INPUT option may not be used with a datafile backup set

1 Answers  


RMAN-12011: multiple records for default device type found in catalog

1 Answers  


PROT-00807: Please ensure you have file creation privileges in the executing directory before running this tool.

1 Answers  


Categories