From oracle-l-bounce@freelists.org Thu Jan 20 18:21:15 2005 Return-Path: Received: from air891.startdedicated.com (root@localhost) by orafaq.com (8.12.10/8.12.10) with ESMTP id j0L0LF4i011984 for ; Thu, 20 Jan 2005 18:21:15 -0600 X-ClientAddr: 206.53.239.180 Received: from turing.freelists.org (freelists-180.iquest.net [206.53.239.180]) by air891.startdedicated.com (8.12.10/8.12.10) with ESMTP id j0L0LFxu011980 for ; Thu, 20 Jan 2005 18:21:15 -0600 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 1236E72C09C; Thu, 20 Jan 2005 18:20:33 -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 04349-13; Thu, 20 Jan 2005 18:20:33 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 4672972C447; Thu, 20 Jan 2005 18:19:07 -0500 (EST) X-Amazon-Corporate-Relay: smtp-out-1002.vdc.amazon.com X-AMAZON-TRACK: oracle-l@freelists.org X-MimeOLE: Produced By Microsoft Exchange V6.5.7226.0 Content-class: urn:content-classes:message MIME-Version: 1.0 Content-type: text/plain; charset=us-ascii Content-Transfer-Encoding: 8bit Subject: RE: Ora-600 on 10.1.0.3 (Red Hat Enterprise Linux AS release 3 (Taroon Update 3)) Date: Thu, 20 Jan 2005 15:16:44 -0800 Message-ID: X-MS-Has-Attach: X-MS-TNEF-Correlator: Thread-Topic: Ora-600 on 10.1.0.3 (Red Hat Enterprise Linux AS release 3 (Taroon Update 3)) Thread-Index: AcT/QwNw8dQf+d55R2C3m4Ua+6L5KQAAu62w From: "Parker, Matthew" To: , X-archive-position: 15060 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: matthewp@amazon.com Precedence: normal Reply-To: matthewp@amazon.com X-list: oracle-l X-Virus-Scanned: by amavisd-new at freelists.org X-Spam-Status: No, hits=0.0 required=5.0 tests=none autolearn=ham version=2.60 X-Spam-Level: X-Spam-Checker-Version: SpamAssassin 2.60 (1.212-2003-09-23-exp) on air891.startdedicated.com Check out=20 Note:285906.1 And previous bug for 10.1.0.2 (3599503).=20 -----Original Message----- From: oracle-l-bounce@freelists.org = [mailto:oracle-l-bounce@freelists.org] On Behalf Of Adam Donahue Sent: Thursday, January 20, 2005 2:54 PM To: oracle-l@freelists.org Subject: Ora-600 on 10.1.0.3 (Red Hat Enterprise Linux AS release 3 = (Taroon Update 3)) Folks, We're encountering an ora-600 from the following statement, run in = against a 10g database: ORA-00600: internal error code, arguments: [qctVCO:csform], [0], [0], = [0], [0], [1], [1], [0] Anyone seen this? It happens when we issue an update with a two-level = subselect as part of the column list, e.g., update tab set col =3D ( = select ... where col2 in ( select ... ) ) ) (not correlated). I'll send = more SQL if anyone can confirm they've seen the issue. (Can't really = send it as-is for security reasons.) I've searched Metalink, the ORA-600 lookup tool, Google and some other = sources to no avail. Thanks, Adam -- http://www.freelists.org/webpage/oracle-l -- http://www.freelists.org/webpage/oracle-l