Speed up import with blobs

Hi there,
I had a difficult to import a 2G+ table with several blobs. In fact I'm a newbie to lobs/blobs. At first I wanted to drop all indexes for this table before import and then re-create them afterwards. However, I found each blob column associated with a lob index, which created by system...

So my question now is can I drop these blob column indexes and re-create them after the import done? In addition, any possible way to disable the archive log generation during import without restarting the Oracle instance?

Any input would be appreciate. Thanks in advance.

Dicky Received on Tue Aug 13 2002 - 08:56:58 CDT