ORA-600 when querying DBA_SOURCE, ALL_SOURCE.

From: Thomas Jeff <ThomasJe_at_tce.com>
Date: Thu, 20 Sep 2001 06:34:39 -0700
Message-ID: <F001.00393869.20010920064519@fatcity.com>

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_at_tce.com
DBA Quickplace: http://gkmqp.tce.com/tis_dba

---

Received on Thu Sep 20 2001 - 08:34:39 CDT