ORA-39296: Cannot alter index partitioning type or partitioning columns.

曾春华

ORA-39296: Cannot alter index partitioningtype or partitioning columns.

Cause: DBMS_METADATA_DIFF wascomparing two indexes with incompatible

partitioning: (1) one is partitioned and one is not (2)both are partitioned but in

different ways (locally vs. globally, hash vs. range) (3)both are partitioned but on

different columns. There is no SQL ALTER statement tochange the way an index

is partitioned.

Action: The difference cannot beeliminated with an SQL ALTER statement.