How to do a large insert to a table

[tamilselvan]

Follow the steps:
1 Calculate the disk space required for this table.
2 Create all extents
3 Create a big rollback segment
4 Alter table to nologging
5 Disable all indexes and constraints
6 Set autocommit to 10000
7 Assign the rollback segment
8 Start insert the rows now.
9 Enable the indexes and constraints
10 ALTER table to logging