ORA-14279: index mismatch for tables in ALTER TABLE EXCHANGE
SUBPARTITION

Answers were Sorted based on User's Feedback



ORA-14279: index mismatch for tables in ALTER TABLE EXCHANGE SUBPARTITION..

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

ORA-14279: index mismatch for tables in ALTER TABLE EXCHANGE SUBPARTITION..

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

Post New Answer

More Oracle Errors Interview Questions

NID-00001: Illegal command line syntax - parse error = (number)

1 Answers  


RMAN-10004: unable to connect to recovery catalog

1 Answers  


CLSR-01011: Invalid instance startup mode [string] is specified

1 Answers  


NNL-00352: Cancelled save config

1 Answers  


NNL-00308: Server dumping its cache to the trace file

1 Answers  






LSX-00212: value "~1s" whose total digits exceeds ~2d

1 Answers  


ORA-38473: cannot drop a type used for Expression Filter attribute set

1 Answers  


SQL*Loader-00601: For INSERT option, table must be empty. Error on table string

1 Answers  


TNS-12640: Authentication adapter initialization failed

1 Answers  


ORA-09851: soacon: Archmon unable to lock named pipe.

1 Answers  


TNS-01006: set password : set the password for subsequent calls

1 Answers  


ORA-08445: syntax error in SIGN clause in mask options

1 Answers  


Categories