SQL>
SQL> create table big_table as select * from all_objects where 1=0;
Table created.
SQL>
SQL> set autotrace on statistics;
SQL>
SQL> insert into big_table select * from all_objects where rownum < 50;
SQL> insert /*+ APPEND */ into big_table select * from all_objects where rownum < 50;
SQL> commit;
Commit complete.
SQL> alter table big_table nologging;
Table altered.
SQL> insert into big_table
2 select * from all_objects where rownum < 50;
49 rows created.
SQL> insert /*+ APPEND */ into big_table
2 select * from all_objects where rownum < 50;
49 rows created.
SQL> commit;
Commit complete.
SQL>
SQL> drop table big_table;
Table dropped.
SQL>