Interested to Buy Any Domain ? << Click Here >> for more details...
ORA-14098: index mismatch for tables in ALTER TABLE EXCHANGE
PARTITION
- 1 Answers
- 5185 Views
- I also Faced
- E-Mail Answers
Answer / guest
Cause: The two tables specified in the EXCHANGE 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 ? | 0 Yes | 0 No |
ORA-32774: more than one file was specified for bigfile tablespace string
ORA-19633: controlfile record string is out of sync with recovery catalog
QSM-02008: non-join filter condition in WHERE or HAVING clause
TNS-00287: Min Connect Time (secs) : number
ORA-00064: object is too large to allocate on this O/S (string,string)
PLS-00646: MAP or ORDER method must be defined in the root of the subtype hierarchy
ORA-16530: invalid buffer or length
ORA-07259: spdcr: exec error, detached process failed in startup.
ORA-00335: online log string: No log with this number, log does not exist
PLS-00135: Pragma string expects 3rd argument to be an identifier, string or numeric literal
ORA-24030: Only one of rule or rule-set must be specified
RMAN-06596: to use CONVERT compatibility must be set to 10.0.0 or greater, currently set to string
Oracle Errors 
