Alter Table Move Partition Compress. Mark bitmap indexes UNUSABLE. And this errors occurs after it.
To compress the existing data in the partition you must move the partition. SQL insert into TEST_IOT_TBL values 2Mtest2. If you use the MOVE statement then the local indexes for partition sales_q1_1998 become unusable.
While the table is being moved it is online for read activity but has an exclusive X lock so all DML will be blocked until the move command completes.
And then rebuildnot recreated all indexes manually preferably with reasonable parallel option. ALTER TABLE MOVE TABLESPACE ALTER TABLEMOVE enables you to relocate data of a non-partitioned table or of a partition of a partitioned table into a new segment and optionally into a different tablespace. A similar action could be performed for an individual partition of a partitioned table. It is very important to choose to compress the tables in NEW tablespace as compressing them alone doesnt reorganize the extents in the datafiles in a way for them to be able to.
