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

ORA-23397: global name "string" does not match database link name "string"

1 Answers  


PLS-00170: the SQL statement in an OPEN statement or FOR loop must be a SELECT

1 Answers  


ORA-39044: Metadata transform string has already been specified.

1 Answers  


ORA-00237: snapshot operation disallowed: controlfile newly created

1 Answers  


LSX-00124: "list" element is improperly defined

1 Answers  


ORA-00063: maximum number of LOG_FILES exceeded

1 Answers  


ORA-07412: sfaslv: Error getting entry in asynchronous write array.

1 Answers  


NNO-00606: disabling modification requests

1 Answers  


ORA-00122: cannot initialize network configuration

1 Answers  


ORA-09876: TASDEF_CLOSE: unable to close ?/dbs/tasdef@.dbf file.

1 Answers  


QSM-02028: group by CUBE

1 Answers  


ORA-26095: unprocessed stream data exists

0 Answers  


Categories