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-14290: PRIMARY KEY constraint mismatch in ALTER TABLE
EXCHANGE [SUB]PARTITION



ORA-14290: PRIMARY KEY constraint mismatch in ALTER TABLE EXCHANGE [SUB]PARTITION..

Answer / guest

Cause: The corresponding columns in the tables specified in
the ALTER TABLE EXCHANGE [SUB]PARTITION statement have
different PRIMARY KEY constraints.

Action: Ensure that the two tables do not have PRIMARY KEY
constraints defined on any column or disable all PRIMARY KEY
constraints on both tables. Then retry the operation.

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

ORA-14621: cannot add subpartition when DEFAULT subpartition exists

1 Answers  


ORA-06604: LU6.2 Driver: Unable to allocate session with remote LU

1 Answers  


RMAN-08582: channel string: starting archive copy

1 Answers  


ORA-08101: index key does not exist file string: (root string, node string) blocks (string)

1 Answers  


EXP-00092: Unable to set NLS_NUMERIC_CHARACTERS to required defaults.

1 Answers  


ORA-30377: MV_CAPABILITIES_TABLE not found

1 Answers  


ORA-38480: creation of system trigger EXPFIL_ALTEREXPTAB_MAINT failed.

1 Answers  


SQL*Loader-00528: OCI return status: error

1 Answers  


ORA-30109: could not open parameter file 'string'

1 Answers  


ORA-31600: invalid input value string for parameter string in function string

1 Answers  


UDI-00004: operation generated ORACLE error number

1 Answers  


CLSR-00510: Unable to load NLS data

1 Answers  


Categories