ORA-14288 when setting default attributes on an index partition
I need to change the tablespace where 7 indexes are created. This is a 3TB
partitioned index. A new partition is created each day and then folded
into months. The command I am running is
alter index myindex1 modify default attributes for partition
mypartition tablespace myNewIndexTablespace;
The error is
ORA-14288 index is not partitioned by composite range method Cause: The
index in a partition or subpartition maintenance operation command must be
partitioned by composite range method.
I am trying to figure out the best approach here considering these indexes
are big and reside on 52 partitions.
No comments:
Post a Comment