Is it possible to compress local subpartitioned index using ALTER INDEX statement?
Hi guys...
I know a local partitioned index can be compressed on the time of its creation.
But....Is there any way for compressing the local partitioned index after its creation using ALTER INDEX?
Plz check this link
https://docs.oracle.com/database/121/SQLRF/statements_1012.htm#SQLRF00805
ALTER INDEX allows to use NOCOMPRESS in it but no COMPRESS option even though it is mentioned the same in above documentation.
test_index1 is a locally partitioned index already created on a table.
----------------------------------------------------------------------------------------------------------------------------------------------
SQL> ALTER INDEX test_index1 REBUILD partition SYS_P28364 NOCOMPRESS ONLINE;
Index altered
----------------------------------------------------------------------------------------------------------------------------------------------
SQL> ALTER INDEX test_index1 REBUILD COMPRESS ONLINE;