Interested to Buy Any Domain ? << Click Here >> for more details...
ORA-14279: index mismatch for tables in ALTER TABLE EXCHANGE
SUBPARTITION
- 2 Answers
- 5426 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-02345: cannot create a view with column based on CURSOR operator
NNL-00008: request not understood by server
ORA-28537: no more result sets
QSM-00785: the directive string is not supported for task string at this time
DRG-12507: stop word string already exists in this stoplist
ORA-01913: EXCLUSIVE keyword expected
ORA-14322: DEFAULT partition already exists
ORA-30033: Undo tablespace cannot be specified as default user tablespace
ORA-04020: deadlock detected while trying to lock object stringstringstringstringstring
DRG-13101: partition string does not exist in this index
ORA-36314: (PHYS01) workspace object must be a dimension, relation or variable.
TNS-01009: service [<listener_name>] : get the service information of the listener
Oracle Errors 
