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

NNL-00930: Requests refused, unknown data type: number

1 Answers  


ORA-15068: maximum number of diskgroups string already mounted

1 Answers  


DRG-11618: URL store: document identified by string is too large

1 Answers  


RMAN-06470: DEVICE TYPE is supported only when automatic channels are used

1 Answers  


RMAN-08059: media recovery failed

1 Answers  


ORA-13754: "SQL Tuning Set" "string" does not exist.

2 Answers  


NID-00404: DBNEWID - Completed succesfully.

1 Answers  


NZE-29017: The premaster secret length is incorrect.

1 Answers  


LPX-00277: no closing quote was seen

1 Answers  


DRG-50924: PL/SQL inside PL/SQL not supported

1 Answers  


ORA-16741: The destination parameter of standby "string" has the wrong syntax.

1 Answers  


NNL-00834: Slowest delete processing time: string

1 Answers  


Categories