Re: really wierd error

From: Anurag Varma <avdbi_at_hotmail.com>
Date: Sat, 20 Sep 2003 15:40:22 GMT
Message-ID: <Gx_ab.2085$jo2.485@nwrddc03.gnilink.net>

"Ryan Gaffuri" <rgaffuri_at_cox.net> wrote in message news:1efdad5b.0309200513.635b4da9_at_posting.google.com...
> I did a massive delete of about 17 million records and 2.5GB of data.
> Delete completed, but my auto-trace had an error. you ever see this
> before?
>
>
> Statistics
> ----------------------------------------------------------
> 129078 recursive calls
> 64818220 db block gets
> 180736852 consistent gets
> 38082890 physical reads
> SP2-0642: SQL*Plus internal error state 1075, context 1:4:0
> Unsafe to proceed
> 650 bytes sent via SQL*Net to client
> 665 bytes received via SQL*Net from client
> 3 SQL*Net roundtrips to/from client
> 6 sorts (memory)
> 0 sorts (disk)
> 15919615 rows processed

Not sure .. but I think I've seen this kind of error originate due to wrong env settings ...
double check them.

Anurag Received on Sat Sep 20 2003 - 10:40:22 CDT