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-33280: (DBERR10) Analytic workspace string cannot be attached in MULTI mode until the changes made and updated in RW or EXCLUSIVE mode are committed or rolled back.

1 Answers  


CLSR-00002: Oracle error encountered while executing string

1 Answers  


RMAN-04021: target database DBID string does not match channel's DBID string

1 Answers  


AMD-00116: PROCEDURE string, read error

1 Answers  


ORA-13381: table:string not found in network:string

1 Answers  


ORA-16018: cannot use string with LOG_ARCHIVE_DEST_n or DB_RECOVERY_FILE_DEST

1 Answers  


PCB-00322: EXEC SQL LOB statements an Oracle extension

1 Answers  


PCC-02324: found variable name used as a typedef name

1 Answers  


ORA-30075: TIME/TIMESTAMP WITH TIME ZONE literal must be specified in CHECK constraint

1 Answers  


RMAN-06140: cannot specify TAG option with LIST INCARNATION

1 Answers  


ORA-12342: open mounts exceeds limit set on the OPEN_MOUNTS parameter

1 Answers  


LFI-00118: Unable to change type to Unknown.

1 Answers  


Categories