Importing database with LONG colum

Hei,

We have a Oracle 7.3.3 database running on Solaris 2.51. The size of the database is about 10Gb. Many of the tables in the database have long columns.
Every night we take an export of the database on to tape which takes about 9 hours.
Because of a disk-failure we needed to import the whole database using Oracle import utility reading the data from tape. But, the import process takes a very very long time (three days) and I was wondering if any of you have any ideas on why that could be.
I have been monitoring the importing process periodically and I notice that tables containing columns of the type LONG is very very slow to be imported while tables without LONG columns are loaded at a satisfactory speed. I have hear roumers that Oracle's utilities does not handle the LONG type very well, but I do not have any reliable source on that.

Is it normal that an export process taking 9 hours should take 3 days to import?

The parameter file I am using look like:

FILE=/dev/rmt/0n
LOG=do_imp.log
FULL=Y
COMMIT=Y
BUFFER=40000000 Would the time it takes to import the data be much shorter if I used COMMIT=N instead?

Comments?

Thanks,

Thor Morten Kopaas Received on Fri Apr 16 1999 - 04:41:10 CDT