RE: ORACLE 9.2.0.5 bug with SQL LOADER direct load !!!
- From: "Khedr, Waleed" <Waleed.Khedr@xxxxxxx>
- To: <oracle-l@xxxxxxxxxxxxx>
- Date: Wed, 21 Apr 2004 14:54:51 -0400
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@xxxxxxxxxxxxxxx]
Sent: Wednesday, April 21, 2004 2:38 PM
To: oracle-l@xxxxxxxxxxxxx
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@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
> -----------------------------------------------------------------
>=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@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
-----------------------------------------------------------------
----------------------------------------------------------------
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:
