Re: Slow import

Robert Doolittle wrote:
>
> I am importing a table that seems to be taking an unusual amount of time.
> I am using Oracle 7.2.2 on SCO Open Server 5. My hardware is a Pentium Pro
> 200 w/256 megs memory, hardware based RAID w/128 megs memory cache on the
> RAID controller. A total of 10 gigs storage. The table is two columns with
> 20 characters in each column. There are 22 million rows. The export file was
> done to disk. A non buffered import statement creates problems with my
> rollback segment. I pre-created the table and index to change the storage
> parameters.The export took about ten minutes. I used the following import
> statement.
>
> imp user1/users1 file=/expdat.dmp tables=mytable indexes=y ignore=y
> buffer=10000 commit=y
>
> I have tried this with various size buffers and seem to get the same
> results. Any suggestions would be greatly appreciated.
>
> Thank you
> robdool_at_centrelab.com

Also try using commit=n .
ie you commit at the end of the transaction of the load. Commit at the end of each row import puts a lot of load. Please see to it that your rollback segments are big enough.

-- 
Sanjay T. Mathew (alsm1_at_micro.lucent.com)
Oracle DBA