From oracle-l-bounce@freelists.org Wed Apr 21 13:52:09 2004 Return-Path: Received: from air189.startdedicated.com (root@localhost) by orafaq.com (8.11.6/8.11.6) with ESMTP id i3LIq9l30153 for ; Wed, 21 Apr 2004 13:52:09 -0500 X-ClientAddr: 206.53.239.180 Received: from turing.freelists.org (freelists-180.iquest.net [206.53.239.180]) by air189.startdedicated.com (8.11.6/8.11.6) with ESMTP id i3LIq8630148 for ; Wed, 21 Apr 2004 13:52:08 -0500 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id C5CC372DAAA; Wed, 21 Apr 2004 13:44:49 -0500 (EST) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 28962-93; Wed, 21 Apr 2004 13:44:49 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id BDCE372E7B5; Wed, 21 Apr 2004 13:44:39 -0500 (EST) Received: with ECARTIS (v1.0.0; list oracle-l); Wed, 21 Apr 2004 13:43:20 -0500 (EST) X-Original-To: oracle-l@freelists.org Delivered-To: oracle-l@freelists.org Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 59D1672E067 for ; Wed, 21 Apr 2004 13:43:19 -0500 (EST) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 28962-51 for ; Wed, 21 Apr 2004 13:43:19 -0500 (EST) Received: from maillnx-us111.fmr.com (maillnx-us111.fmr.com [192.223.198.26]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id BE57072E316 for ; Wed, 21 Apr 2004 13:43:18 -0500 (EST) Received: from virmro110nts.fmr.com (VIRMRO110NTS.fmr.com [172.26.5.98]) by maillnx-us111.fmr.com (Switch-3.1.2/Switch-3.1.0) with SMTP id i3LIsq9c013576 for ; Wed, 21 Apr 2004 14:54:52 -0400 Received: from MSGBOSCLF2WIN.fmr.com ([10.46.17.175]) by MSGMROIM01WIN.DMN1.FMR.COM with Microsoft SMTPSVC(5.0.2195.6713); Wed, 21 Apr 2004 14:54:51 -0400 X-MimeOLE: Produced By Microsoft Exchange V6.0.6521.0 content-class: urn:content-classes:message Subject: RE: ORACLE 9.2.0.5 bug with SQL LOADER direct load !!! MIME-Version: 1.0 Content-type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: 8bit Date: Wed, 21 Apr 2004 14:54:51 -0400 Message-ID: <42BBD772AC30EA428B057864E203C9991158E1@MSGBOSCLF2WIN.DMN1.FMR.COM> X-MS-Has-Attach: X-MS-TNEF-Correlator: Thread-Topic: ORACLE 9.2.0.5 bug with SQL LOADER direct load !!! Thread-Index: AcQn0D69uZIjOShQTiqqxg7bAhpGaAAAE8Tw From: "Khedr, Waleed" To: X-OriginalArrivalTime: 21 Apr 2004 18:54:51.0586 (UTC) FILETIME=[208BBA20:01C427D2] X-Virus-Scanned: by amavisd-new at freelists.org X-archive-position: 3475 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: Waleed.Khedr@FMR.COM Precedence: normal Reply-To: oracle-l@freelists.org X-list: oracle-l X-Virus-Scanned: by amavisd-new at freelists.org 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@wangtrading.com] Sent: Wednesday, April 21, 2004 2:38 PM To: oracle-l@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@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@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@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 -----------------------------------------------------------------