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.

Filed under:
Oracle
Post a Comment