ORACLE 9.2.0.5 bug with SQL LOADER direct load !!!

From: dba1 mcc <mccdba1_at_yahoo.com>
Date: Wed, 21 Apr 2004 11:20:20 -0700 (PDT)
Message-ID: <20040421182020.12997.qmail@web60802.mail.yahoo.com>

We just migrated from ORACLE 9.1.0.4 to 9.2.0.5 on SUN Solaris and LINUX. There has one bug happen on ORACLE SQLLOADER with "direct=true". The bug number are 3555220 and 3531336 9NOT on Metalink yet). If you have support contract you can ask ORACLE for document ID: 269170.1 (NOT on Metalink yet).

The problem happen on both Solaris on LINUX when you use SQLLODER with "direct=true". The load may finish successful or may have following error messages:

SQL*Loader: Release 9.2.0.5.0 - Production on Wed Apr 21 09:53:04 2004

SQL*Loader-961: Error calling once/load finishing for table TAX
ORA-03113: end-of-file on communication channel SQL*Loader-2026: the load was aborted because SQL Loader cannot continue.
SQL*Loader-925: Error while uldlgs: OCIStmtExecute
(ptc_hp)

ORA-03114: not connected to ORACLE
SQL*Loader-925: Error while uldlgs: OCIStmtFetch
(ptc_hp)

ORA-24338: statement handle not executed

If you use sqlplus to select data and you will find index corrupt:

select count(*) from tableXXX;
*
ERROR at line 1:
ORA-01502: index 'XXXXX' or partition of such index is in unusable state

Follow Document ID 269170.1 to fix this problem.

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 - 13:18:17 CDT