RE: ora-600 errors for X_$KCBCBH & x_$kcbrbh

Roy:

This is a cut-and-paste from the Oracle TAR.

HTH,
Mike

For the x_$ view not able to recompile successfully:

• issue the following query and note the object_id: SQL> select object_id, object_name from dba_objects where object_name='X$<whatever>' and owner='SYS';
• issue SQL> delete from dependency$ where d_obj# in (<obj# from previous select statement>);
• drop the view using the DROP command
• flush the shared pool
• bounce the instance with shutdown abort, startup, shutdown immediate and startup.

In a test, use the X_$KCBCBH view and apply this process. Report back results before proceeding with other views.

Thanks,

~ Stefan.

-----Original Message-----
From: Roy Armstrong [mailto:RArmst1_at_smud.org] Sent: Thursday, July 17, 2003 6:59 PM
To: Vergara, Michael (TEM)
Subject: ora-600 errors for X_$KCBCBH & x_$kcbrbh

Hi,

I have this problem and would be interested in seeing the solution from the tar. Thank you for your help. Received on Fri Jul 18 2003 - 09:16:49 CDT