Re: Slow import

Drop the index, say index=N, and try the import again. Then create the index manually afterwards. I'll be willing to bet you see a tremendous increase !! :-)
Alan V

Robert Doolittle wrote in message <6c1ru1$brh$1_at_ns2.naccess.net>...
>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