alter index big_table_idx rebuild nologging : Alter Index « Index « Oracle PL/SQL Tutorial

1. Oracle PL/SQL Tutorial
2. Index
3. Alter Index

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.