Re: ORACLE 9.2.0.5 bug with SQL LOADER direct load !!!

From: Paul Drake <discgolfdba_at_yahoo.com>
Date: Wed, 21 Apr 2004 16:50:11 -0700 (PDT)
Message-ID: <20040421235011.11839.qmail@web20420.mail.yahoo.com>

• Mladen Gogala <mladen_at_wangtrading.com> 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_at_freelists.org put 'unsubscribe' in the subject line.

--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------

Received on Wed Apr 21 2004 - 18:47:10 CDT