RE: 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
<G> :P
<SPAN

class=087214114-20092001> 
<SPAN

class=087214114-20092001>Mark

  <FONT face=Tahoma
  size=2>-----Original Message-----From: root_at_fatcity.com   [mailto:root_at_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 <FONT   face="Courier New" size=2>view text for DBA_SOURCE:   select u.name, o.name,
  decode(o.type#, 7,
  'PROCEDURE', 8, 'FUNCTION', 9, 'PACKAGE', <FONT color=#000000   face="Courier New" size=2>11, 'PACKAGE BODY', 13, 'TYPE', 14, 'TYPE   BODY', 'UNDEFINED'),
  s.line, s.source from
  sys.obj$ o, sys.source$ s, sys.user$ u <FONT color=#000000   face="Courier New" size=2>where o.obj# = s.obj# <FONT color=#000000   face="Courier New" size=2>and o.owner# = u.user# <FONT   color=#000000 face="Courier New" size=2>and o.type# in (7, 8, 9, 11, 13,

1. union select u.name, o.name, 'JAVA SOURCE', s.joxftlno, s.joxftsrc <FONT color=#000000 face="Courier New" size=2>from sys.obj$ o, x$joxfs s, sys.user$ u where o.obj# = s.joxftobn and o.owner# = u.user# <FONT color=#000000 face="Courier New" size=2>and o.type# = 28; I can query either side of the UNION separately and it works fine. <FONT color=#000000 face="Courier New" size=2>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 <FONT color=#000000 face="Courier New" size=2>IBM RS600, AIX 4.3.3, 8.1.7.0, on UTF8, FWIW.  <FONT face="Courier New" size=2>-------------------------------------------- <FONT face="Courier New" size=2>Jeffery D Thomas <FONT face="Courier New" size=2>DBA Thomson Information Services Thomson multimedia Inc. Email: thomasje_at_tce.com <FONT face="Courier New" size=2>DBA Quickplace: <A href="http://gkmqp.tce.com/tis_dba" target=_blank>http://gkmqp.tce.com/tis_dba <FONT face="Courier New" size=2>--------------------------------------------