From mark@cool-tools.co.uk Thu, 20 Sep 2001 07:32:27 -0700 From: "Mark Leith" Date: Thu, 20 Sep 2001 07:32:27 -0700 Subject: RE: ORA-600 when querying DBA_SOURCE, ALL_SOURCE. Message-ID: MIME-Version: 1.0 Content-Type: text/plain Title: ORA-600 when querying DBA_SOURCE, ALL_SOURCE. Works OK with 8.1.7 on Win2K.. What do all you unix bigots think of that then :P   Mark -----Original Message-----From: root@fatcity.com [mailto:root@fatcity.com]On Behalf Of Thomas JeffSent: Thursday, September 20, 2001 15:45To: Multiple recipients of list ORACLE-LSubject: ORA-600 when querying DBA_SOURCE, ALL_SOURCE. And yes, I've got a TAR logged with Oracle on this, but I wonder if any of you have seen anything like this before.   Whenever we try to query any of the *_SOURCE views we get an ORA-600.   If you look at the view text for DBA_SOURCE: select u.name, o.name, decode(o.type#, 7, 'PROCEDURE', 8, 'FUNCTION', 9, 'PACKAGE', 11, 'PACKAGE BODY', 13, 'TYPE', 14, 'TYPE BODY', 'UNDEFINED'), s.line, s.source from sys.obj$ o, sys.source$ s, sys.user$ u where o.obj# = s.obj# and o.owner# = u.user# and o.type# in (7, 8, 9, 11, 13, 14) union select u.name, o.name, 'JAVA SOURCE', s.joxftlno, s.joxftsrc from sys.obj$ o, x$joxfs s, sys.user$ u where o.obj# = s.joxftobn and o.owner# = u.user# and o.type# = 28; I can query either side of the UNION separately and it works fine. It's when the whole shembang is queried where the ORA-600 occurs. And I've rebuilt with catalog, etc.   Doesn't help.   We are on IBM RS600, AIX 4.3.3, 8.1.7.0, on UTF8, FWIW.  -------------------------------------------- Jeffery D Thomas DBA Thomson Information Services Thomson multimedia Inc. Email: thomasje@tce.com DBA Quickplace: http://gkmqp.tce.com/tis_dba --------------------------------------------