ORA-14098: index mismatch for tables in ALTER TABLE EXCHANGE
PARTITION
- 1 Answers
- 4527 Views
- I also Faced
- E-Mail Answers
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 |
PCC-00041: Unable to open output file "string"
PLS-00227: subprogram 'in' formal string is not yet denotable
ORA-24416: Invalid session Poolname was specified.
LPX-00307: namespace prefix ~S used but not declared
ORA-25123: Too many components specified in the name.
NNO-00851: LDAP open/bind failed: error = number
ORA-29309: export dump file was generated by different version of DBMS_PITR package
RMAN-06073: file header is corrupt for datafile string
QSM-01018: single table materialized join view rewrite not required
RMAN-20205: incomplete UNTIL clause
ORA-00127: dispatcher string does not exist
PCC-00120: File I/O error during code generation
Oracle Errors 
