Oracle PL/SQL Tutorial/Index/Alter Index
alter index big_table_idx rebuild nologging
<source lang="sql">
SQL> SQL> create table big_table as select * from all_objects; Table created. SQL> SQL> create index big_table_idx on
2 big_table(owner,object_type,object_name);
Index created. SQL> SQL> insert /*+ APPEND */ into big_table
2 select * from all_objects;
12653 rows created. SQL> SQL> alter index big_table_idx unusable; Index altered. SQL> SQL> alter session set skip_unusable_indexes=true; Session altered. SQL> SQL> insert /*+ APPEND */ into big_table
2
SQL> alter index big_table_idx rebuild nologging; Index altered. SQL> SQL> SQL> drop table big_table; Table dropped.</source>