Originally Posted by
syedfarukhali
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.
Be carefull with using no commit, if the table is very large you will blow out your undo and then that table import will rollback and you will have to re-import it, and that sucks.
I prefer using a buffer and commit to avoid that.
COMMIT=Y
BUFFER=12000000
Something like that helps, you will also avoid the rare instance (IME) where the default buffer is not large enough to swallow the longest column in the table, I've seen that once or twice.
I remember when this place was cool.
Reply With Quote