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-14098: index mismatch for tables in ALTER TABLE EXCHANGE
PARTITION



ORA-14098: index mismatch for tables in ALTER TABLE EXCHANGE PARTITION..

Answer / guest

Cause: The two tables specified in the EXCHANGE have indexes
which are not equivalent

Action: Ensure that the indexes for the two tables have
indexes which follow this rule For every non partitioned
index for the non partitioned table, there has to be an
identical LOCAL index on the partitioned table and vice
versa. By identical, the column position, type and size have
to be the same.

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

NZE-28859: SSL negotiation failure

1 Answers  


ORA-16587: Ambiguous object specified to Data Guard broker

1 Answers  


LSX-00344: namespace values "~1S" and "~2S" differ

1 Answers  


ORA-08274: Out of memory for environment variable

1 Answers  


RMAN-08097: channel string: starting validation of archive log backupset

1 Answers  


ORA-07474: snclrd: close error, unable to close sgadef.dbf file.

1 Answers  


ORA-16612: string value too long for attribute "string"

1 Answers  


ORA-27120: unable to removed shared memory segment

1 Answers  


ORA-19921: maximum number of string rows exceeded

1 Answers  


ORA-13243: specified operator is not supported for 3- or higher-dimensional R-tree

1 Answers  


NPL-00305: unsupported ASN.1 "UNIV" type string

1 Answers  


ORA-33282: (DBERR11) Cannot wait for analytic workspace string to become available since doing so would cause a deadlock.

1 Answers  


Categories