Interested to Buy Any Domain ? << Click Here >> for more details...
ORA-14279: index mismatch for tables in ALTER TABLE EXCHANGE
SUBPARTITION
- 2 Answers
- 5666 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 |
PLS-00601: partition extended object names may only be used with tables
IMG-02012: 2FF12 - illegal specification for thumbnail generation
TNS-12562: TNS:bad global handle
ORA-16188: LOG_ARCHIVE_CONFIG settings inconsistent with previously started instance
NPL-00414: incoming ASN.1 type tag is greater than maximum of 16383
ORA-26079: file "string" is not part of table string.string
ORA-14189: this physical attribute may not be specified for an index subpartition
ORA-19002: Missing XMLSchema URL
ORA-16411: ONDEMAND archival requires active managed recovery operation
TNS-01067: Service display mode is string
ORA-06574: Function string references package state, cannot execute remotely
QSM-01001: query rewrite not enabled
Oracle Errors 
