Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: ORACLE 9.2.0.5 bug with SQL LOADER direct load !!!

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

From: Khedr, Waleed <Waleed.Khedr_at_FMR.COM>
Date: Wed, 21 Apr 2004 14:54:51 -0400
Message-ID: <42BBD772AC30EA428B057864E203C9991158E1@MSGBOSCLF2WIN.DMN1.FMR.COM>


I think your statement is valid only for: - parallel direct loads
- global indexes during direct load into a partition.

Regards,

Waleed

-----Original Message-----
From: Mladen Gogala [mailto:mladen_at_wangtrading.com] Sent: Wednesday, April 21, 2004 2:38 PM
To: oracle-l_at_freelists.org
Subject: Re: ORACLE 9.2.0.5 bug with SQL LOADER direct load !!!

There probably is a bug with SQL*Loader and direct load, but after a direct load, indexes usually are in unusable state. That is to be expected and is not a part of the bug description. The situation is widely described in the oracle manuals, which makes it a feature, not a bug (no, I'm not trying to be funny, it=20 comes naturally)
Also, if you can't see the bug text, it doesn't mean that it is not on Metalink, it only means that it is not open to public yet. I bitterly argued about opening bugs to public with the oracle guy on this list, who is the universal culprit and can be blamed for=20 just about anything, including the bad weather, but he is still=20 not convinced that opening the bug database to the general public=20 (with the support contract, of course) is a good idea. His argument was (and I must partially agree with him) that bugs have to reach certain level of "maturity" (be confirmed as such, and replicated=20 in the test environment). Before that state is reached, bugs are visible to the lucky owner of the database and oracle support only.

On 04/21/2004 02:20:20 PM, dba1 mcc wrote:
> 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=3Dtrue". 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).

>=20

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

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

> Copyright (c) 1982, 2002, Oracle Corporation. All
> rights reserved.
>=20

> 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
>=20

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

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

> Follow Document ID 269170.1 to fix this problem.
>=20
>=20

> =09
> =09
> __________________________________
> 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
> -----------------------------------------------------------------
>=20

--=20
Mladen Gogala
Oracle DBA

Note:
This message is for the named person's use only. It may contain = confidential, proprietary or legally privileged information. No = confidentiality or privilege is waived or lost by any mistransmission. = If you receive this message in error, please immediately delete it and = all copies of it from your system, destroy any hard copies of it and = notify the sender. You must not, directly or indirectly, use, disclose, = distribute, print, or copy any part of this message if you are not the = intended recipient. Wang Trading LLC and any of its subsidiaries each = reserve the right to monitor all e-mail communications through its = networks.
Any views expressed in this message are those of the individual sender, = except where the message states otherwise and the sender is authorized = to state them to be the views of any such entity.



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
-----------------------------------------------------------------
----------------------------------------------------------------
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:52:09 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US