Originally posted by tamilselvan
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.
- The table is already set in NOLOGGING mode
- Freelists and Initrans are enough set.
- System is in NOARCHIVE LOG Mode
- Enough big Preallocated Extents are available
- And inserts are mandatory dependent on the Unique constraint hence cannot drop and recreate.

So, are there any corners i should look into.

Thanx
Jr.