RE: ORA-600 when querying DBA_SOURCE, ALL_SOURCE.

[Mark Leith]

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

 

Mark

-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Thomas Jeff
Sent: Thursday, September 20, 2001 15:45
To: Multiple recipients of list ORACLE-L
Subject: 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: [EMAIL PROTECTED]
DBA Quickplace: http://gkmqp.tce.com/tis_dba
--------------------------------------------