insert /*+ APPEND */ into table nologging select /*+ parallel(t,10) */ * from table1 t; http://www.eygle.com/faq/Nologging&append.htm http://www.itpub.net/forum.php?mod=viewthread&tid=239905