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

KUP-04088: data sampling is not supported by this access driver

1 Answers  


ORA-27546: Oracle compiled against IPC interface version string.string found version string.string

1 Answers  


ORA-14021: MAXVALUE must be specified for all columns

1 Answers  


ORA-12813: value for PARALLEL or DEGREE must be greater than 0

1 Answers  


RMAN-08101: channel string: proxy validation complete

1 Answers  


NNO-00115: line string: single-value data type "string", other instances ignored

1 Answers  


ORA-07247: skgfrfms, skgfrnms: read error, unable to read block from database file

1 Answers  


ORA-22605: FDO handle [string] is not initialized

1 Answers  


ORA-19330: Type 'string'.'string' not installed. Please install the type before using the CREATE_DBURI operator

1 Answers  


ORA-06743: TLI Driver: cannot alloc t_bind

1 Answers  


PLS-00725: type 'string' must be a supertype or subtype of the TREAT expression

1 Answers  


ORA-30695: JDWP message format problem

1 Answers  


Categories