Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Speed up import with blobs
Why can't you test this yourself (in a test table with blobs) and figure it out?
SQL> drop index sys_il0000009657C00003$$;
drop index sys_il0000009657C00003$$
*
ERROR at line 1:
ORA-22864: cannot ALTER or DROP LOB indexes
Anurag
"Dicky" <ccmdicky_at_netvigator.com> wrote in message news:ajb35i$lvs14_at_imsp212.netvigator.com...
> 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 - 21:23:54 CDT