Loading data into tables generates lots of archivelog and the loading process can be slow. Here is a possible solution:

1) direct path load the data into a NOLOGGING table.
2) process the data from there into a GLOBAL TEMPORARY table (mininal redo generated for
inserts - very very little redo)
3) when all of the data is ready to go, alter your_table to nologging and

insert /*+ append */ into YOUR_TABLE select * from global_temp_table;

and do it as one transaction.

These icons link to social bookmarking sites where readers can share and discover new web pages.
  • Digg
  • Sphinn
  • del.icio.us
  • Facebook
  • Mixx
  • Google
  • Furl
  • Reddit
  • Spurl
  • StumbleUpon
  • Technorati