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.
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.
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;