ORA-14279: index mismatch for tables in ALTER TABLE EXCHANGE
SUBPARTITION
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 |
NID-00001: Illegal command line syntax - parse error = (number)
RMAN-10004: unable to connect to recovery catalog
CLSR-01011: Invalid instance startup mode [string] is specified
NNL-00352: Cancelled save config
NNL-00308: Server dumping its cache to the trace file
LSX-00212: value "~1s" whose total digits exceeds ~2d
ORA-38473: cannot drop a type used for Expression Filter attribute set
SQL*Loader-00601: For INSERT option, table must be empty. Error on table string
TNS-12640: Authentication adapter initialization failed
ORA-09851: soacon: Archmon unable to lock named pipe.
TNS-01006: set password : set the password for subsequent calls
ORA-08445: syntax error in SIGN clause in mask options