Problem in inserting large data

[tamilselvan]

For fast inserting rows in Sqlplus, consider the following:
1 Set NOLOGGING to the table before insert
2 Create large extents for the table
3 Set a particular rollback segment (large) for this transaction
4 Ensure that indexes are created on joining columns
5 Set auto commit to 5000
6 Disable indexes on the table that gets inserted new rows
6 Run the insert statement
7 Enable (recreate) the indexes on the inserted table