Interested to Buy Any Domain ? << Click Here >> for more details...
ORA-14279: index mismatch for tables in ALTER TABLE EXCHANGE
SUBPARTITION
- 2 Answers
- 5658 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-13128: current tiling level exceeds user specified tiling level
ORA-27121: unable to determine size of shared memory segment
ORA-01205: not a data file - type number in header is string
ORA-02804: Allocation of memory failed for log file name
ORA-01854: julian date must be between 1 and 5373484
IMG-00810: boundary queue initialization failed
LFI-00003: Internal exception code. icode = [string], [string].
ORA-00437: ORACLE feature is not licensed. Contact Oracle Corp. for assistance
DRG-11427: valid gist level values are string
TNS-12549: TNS:operating system resource quota exceeded
NNL-00814: Total query processing time: string
RMAN-06135: error executing host command: string
Oracle Errors 
