oracle's
answer will be patch to 8.1.7.2, thats what we were told just recently on a
different ora-600 error.
>>> [EMAIL PROTECTED] 09/20/01 10:45AM
>>>
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
--------------------------------------------
|
