oracle's
answer will be patch to 8.1.7.2, thats what we were told just recently on a
different ora-600 error.>>> ThomasJe_at_tce.com 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 <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 face="Courier New"
color=#000000 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 face="Courier New" color=#000000
size=2>where o.obj# = s.obj# <FONT face="Courier New" color=#000000
size=2>and o.owner# = u.user# <FONT face="Courier New" color=#000000
size=2>and o.type# in (7, 8, 9, 11, 13, 14) <FONT face="Courier New"
color=#000000 size=2>union <FONT face="Courier New" color=#000000
size=2>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. <FONT face="Courier New"
color=#000000 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
face="Courier New" color=#000000 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 target=_blank
href="
http://gkmqp.tce.com/tis_dba">
http://gkmqp.tce.com/tis_dba
<FONT face="Courier New"
size=2>--------------------------------------------
Received on Thu Sep 20 2001 - 09:20:13 CDT
