Interested to Buy Any Domain ? << Click Here >> for more details...
ORA-14279: index mismatch for tables in ALTER TABLE EXCHANGE
SUBPARTITION
- 2 Answers
- 5534 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 |
NNC-00402: program interface de-initialization failed
IMP-00001: respond with either string, string, RETURN or '.' to quit
PROC-00012: Out of heap memory.
ORA-29308: view TS_PITR_CHECK failure
ORA-16014: log string sequence# string not archived, no available destinations
ORA-16406: Primary and standby database software version mismatch
ORA-30741: WITH HIERARCHY OPTION can be specified only for SELECT privilege
SQL*Loader-00306: Token longer than max allowable length of number chars
ORA-19592: wrong string conversation type
ORA-38409: invalid name or option for the attribute set: string
NZE-29190: Multiple entries in OID
ORA-03238: unable to extend LOB segment string.string subpartition string by string in tablespace string
Oracle Errors 
