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
1 Reply
Tag Archives: alter
How to change column data type
How to change column data type, to VARCHAR2 in this example:
ALTER TABLE <table_name> MODIFY (<column_name> VARCHAR2(20));
Note that data may be lost in this operation.
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;