Oracle PL/SQL Tutorial/Index/Alter Index

alter index big_table_idx rebuild nologging

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.