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.
