Re: ORACLE 9.2.0.5 bug with SQL LOADER direct load !!!
- From: Paul Drake <discgolfdba@xxxxxxxxx>
- To: oracle-l@xxxxxxxxxxxxx
- Date: Wed, 21 Apr 2004 16:50:11 -0700 (PDT)
--- Mladen Gogala <mladen@xxxxxxxxxxxxxxx> wrote:
>
> On 04/21/2004 03:23:19 PM, "Khedr, Waleed" wrote:
> > Mladen, this is when you specify parallel=3Dtrue
>
> In my load scripts, that parameter is ALWAYS
> specified.
> If you can't load it in parallel, direct and
> nologging mode,
> then it's not worth loading.
>
> --
> Mladen Gogala
> Oracle DBA
Mladen,
we hit this also, on both win32 and lin32 (RHEL 3.0
ES).
It is fixed in 10.1.0.2 (win32).
the trace file showed that a line of all nulls was
attempted to be inserted. It seems that the sql loader
routine was attempting to insert beyond end of file.
I'd be very interested in comparing notes on this.
The test case here was that a secondary index on an
IOT was invalid, but also that the sql loader process
failed (hence the trace file generated).
I've been out, so I did not yet open an iTAR.
Paul
__________________________________
Do you Yahoo!?
Yahoo! Photos: High-quality 4x6 digital prints for 25¢
http://photos.yahoo.com/ph/print_splash
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Other related posts:
