Slow import

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 Received on Fri Feb 13 1998 - 00:00:00 CST