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-00369: Current log of thread string not useable and other log being cleared

1 Answers  


LPX-00280: HTTP error ~s

1 Answers  


ORA-01639: instance string has no thread assigned to it

1 Answers  


ORA-31044: Top-level prefix length string exceeds maximum string

1 Answers  


ORA-23444: duplicate template parameter

1 Answers  






ORA-28201: Not enough privileges to enable application role 'string'

1 Answers  


NNL-00963: Timeouts, name TTL expired: number

1 Answers  


ORA-30045: No undo tablespace name specified

1 Answers  


ORA-15091: operation incompatible with open handle in this session

1 Answers  


ORA-13054: recursive SQL parse error

1 Answers  


RMAN-06028: duplicate operand specified in restore specification: string

1 Answers  


ORA-14002: only one GLOBAL clause may be specified

1 Answers  


Categories