Interested to Buy Any Domain ? << Click Here >> for more details...
ORA-14279: index mismatch for tables in ALTER TABLE EXCHANGE
SUBPARTITION
- 2 Answers
- 5554 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-26670: STREAMS option requires COMPATIBLE parameter to be string or higher
TNS-12538: TNS:no such protocol adapter
ORA-06733: TLI Driver: failed to receive disconnect
ORA-27001: unsupported device type
DRG-50100: CORE LSF error: string
ORA-24405: error occured while trying to create connections in the pool
ORA-22862: specified object identifier doesn't match existing object identifier
PCC-00113: Value of DBMS option invalid with given value of MODE option
ORA-02786: Size needed for shared region is greater than segment size
RMAN-08126: keep attributes for the proxy copy are changed
TNS-04204: Trace Assistant Internal ERROR: Couldn't Open trace file
PROT-00303: Dump file already exists
Oracle Errors 
