Interested to Buy Any Domain ? << Click Here >> for more details...
ORA-14279: index mismatch for tables in ALTER TABLE EXCHANGE
SUBPARTITION
- 2 Answers
- 5435 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 |
ORA-01905: STORAGE keyword expected
TNS-00525: Insufficient privilege for operation
ORA-01987: client os username is too long
QSM-02091: mv references a non-repeatable or session-sensitive expression
ORA-32839: property string is reserved, names with MGWPROP$_ prefix are not valid
NNL-00411: Minimum response time: string
ORA-22907: invalid CAST to a type that is not a nested table or VARRAY
ORA-27191: sbtinfo2 returned error
TNS-00247: Unable to allocate memory for configuration data from TNSNET.ORA file
DRG-50907: score threshold string outside valid range 1 to 100
NZE-29119: Cannot import certificate.
ORA-31066: Insertion of string into string creates a cycle
Oracle Errors 
