ORA-14279: index mismatch for tables in ALTER TABLE EXCHANGE
SUBPARTITION
- 2 Answers
- 4322 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / guest
Cause: The two tables specified in the ALTER TABLE EXCHANGE
SUBPARTITION 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 ? | 1 Yes | 1 No |
Answer / bits
If the indexes doesn't match between tables, use WITHOUT INDEX clause with partition exchange.
| Is This Answer Correct ? | 0 Yes | 0 No |
NNL-00298: No cache dump currently scheduled
ORA-13762: The string ranking measure is invalid.
ORA-13184: failed to initialize tessellation package
ORA-12236: TNS:protocol support not loaded
ORA-19032: Expected XML tag string got string
ORA-32310: object materialized views must select from an object table
TNS-00024: INTCTL: Unable to contact Navigator to obtain Connection Manager address
ORA-09981: skxfqdreg: Error Adding a page to the SDI buffer pool
PCB-00001: %s
ORA-08308: sllfop: Cannot open file
PLS-00125: type name expected
RMAN-03014: implicit resync of recovery catalog failed
Oracle Errors 
