Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> Re: ** import tuning
The export method has no bearing on the import. I never have had to mess
with recordlength.
For imports I use
buffer=100000 commit=y indexes=n analyze=n
After, I run the indexes in parallel and then analyze using dbms_stats in
parallel.
Don't know if you're importing clobs,longs,blobs etc. Seem to remember that
with longs using buffer and commit inserts one row at a time. though this
was a long time ago
-- http://www.freelists.org/webpage/oracle-lReceived on Mon Jun 06 2005 - 11:02:10 CDT
![]() |
![]() |