Interested to Buy Any Domain ? << Click Here >> for more details...
ORA-14279: index mismatch for tables in ALTER TABLE EXCHANGE
SUBPARTITION
- 2 Answers
- 5539 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 |
TNS-00111: Failed to get configuration data from file
ORA-02262: ORA-string occurs while type-checking column default value expression
QSM-01023: materialized view, string, has GRANT errors
ORA-12452: label tag string already exists
ORA-39064: unable to write to the log file
ORA-13243: specified operator is not supported for 3- or higher-dimensional R-tree
ORA-12022: materialized view log on "string"."string" already has rowid
ORA-30371: column cannot define a level in more than one dimension
ORA-26693: STREAMS string process dropped successfully, but error occurred while dropping rule set string
PCB-00210: DISPLAY-1 only allowed with PIC G and PIC N variables "string"
TNS-04009: %-25s | number
RMAN-06605: old RMAN configuration parameters are successfully deleted
Oracle Errors 
