Interested to Buy Any Domain ? << Click Here >> for more details...
ORA-14279: index mismatch for tables in ALTER TABLE EXCHANGE
SUBPARTITION
- 2 Answers
- 5558 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-14121: MODIFY DEFAULT ATTRIBUTES may not be combined with other operations
QSM-00763: the owner string is invalid while validating user-defined workload string.string
ORA-07266: sppst: invalid process number passed to sppst.
ORA-24304: datatype not allowed for this call
ORA-29886: feature not supported for domain indexes
LSX-00001: NULL pointer
ORA-01219: database not open: queries allowed on fixed tables/views only
ORA-36984: (XSRELGID04) A value cannot be inserted into dimension workspace object.
PLS-00654: PARTITION/ORDER/CLUSTER BY are allowed for only with PARALLEL_ENABLE
NNO-00705: warning: cannot open checkpoint file "string", checkpointing disabled
TNS-12537: TNS:connection closed
PCC-02066: CMD-LINE: Could not find or could not open system config file
Oracle Errors 
