Import takes long time

[syedfarukhali]

Import will anyway build indexes after dataload.. then what's the point?.. only thing that doesnt do is "parallel".. for that use expdp/impdp..

Abhay.

While importing with param index=no indexes will not load in the database
after data load in the database we can give the param indexfile to create the indexes

2)If you are really in Hurry give commit=no while importing it will load the data fast but make sure your rollbaack segment must be very huge.