Database DataWarehousing (MOSC)

MOSC Banner

How to ompress the partition/subpartition of an index

edited May 27, 2010 10:57PM in Database DataWarehousing (MOSC) 4 commentsAnswered
 HI,
Does anyone know syntax to compress the INDEX partition/subpartition. I am trying the following but getting error :

SQL> Alter index INV_DET_TRAFFIC_TYPE_IDX rebuild
  2  subpartition SUBPART_1
  3  TABLESPACE DATA_IDX compress ;
TABLESPACE INDEX_TS compress
                             *
ERROR at line 3:
ORA-14189: this physical attribute may not be specified for an index subpartition


Just to test , I removed the TABLESPACE INDEX_TS clause but error remains the same.

PS : I don't want to drop and recreate index.

Best Regards,
Anurag


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