ORACLE 9.2.0.5 bug with SQL LOADER direct load !!!
- From: dba1 mcc <mccdba1@xxxxxxxxx>
- To: oracle-l@xxxxxxxxxxxxx, oracledba@xxxxxxxxxxx
- Date: Wed, 21 Apr 2004 11:20:20 -0700 (PDT)
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
Copyright (c) 1982, 2002, Oracle Corporation. All
rights reserved.
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@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:
