Oracle Error ORA-39286: Cannot convert between types of index.

Oracle 27 Views 0 Min Read

Oracle Error Message

ORA-39286: Cannot convert between types of index.

Reason for the Error

DBMS_METADATA_DIFF was comparing two indexes of different types, for example, a table index, a domain index, a cluster index, a bitmap index or a bitmap join index There is no SQL ALTER statement to change the type of an index.

Solution

The difference cannot be eliminated with an SQL ALTER statement.

Tags: