How to load huge data in a table:
Increase freelist for the table. Create necessary extents for the table on different datafiles.
Set the table into nologging mode.
Turn off ARCHIVE LOG.
Drop or disable the index before a load.
After the insert, recreate indexes.




Reply With Quote