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>