Database DataWarehousing (MOSC)

MOSC Banner

Is it possible to compress local subpartitioned index using ALTER INDEX statement?

edited Apr 18, 2018 5:09AM in Database DataWarehousing (MOSC) 4 commentsAnswered

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;

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center