Re: Index troubles with SQLLoader

From: Chris Weiss <weisschr_at_pilot.msu.edu>
Date: Tue, 25 May 1999 16:52:44 -0400
Message-ID: <7if2j6$61m$1@msunews.cl.msu.edu>

Drop and recreate your index before you perform the delete.

Chris

<x_at_x.com> wrote in message news:7if5np$eje$1_at_mars.worldonline.fr...
> Hi,
>
> Well, my SQLLoader seems working well but it turns off all constraints on
> the table I load.
> I think it is right but I must enable these constraints manually (with
> schema manager)
> After that, if I try to delete the lines I have loaded, I get the
following
> message :
>
> SQL> delete third where id_ti > 1000;
> delete third where id_ti > 1000
> *
> ERROR Line 1:
> ORA-08102: index key not found, obj # 2697, dba 33578192 (2)
>
> Thanks for help.
>
>
>
Received on Tue May 25 1999 - 15:52:44 CDT