ALTER TABLE t TRUNCATE PARTITION p UPDATE GLOBAL INDEXES;
Instead of “truncate”, we can also use “drop” or “delete”, depending on what kind of operation we need.
Truncate partition without invalidating indexes
Leave a reply
Tag Archives: index
How to move a partitionated index to another tablespace
Change the index’s default tablespace, so it’ll create every new partition on the new tablespace:
ALTER INDEX <index_name> MODIFY DEFAULT ATTRIBUTES TABLESPACE <new_tablespace>;
Move the index’s partition to another tablespace:
ALTER INDEX <index_name> REBUILD PARTITION <partition_name> TABLESPACE <new_tablespace> NOLOGGING;