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----- Sent: Thursday, July 17, 2003 6:59 PM To: Vergara, Michael (TEM) Hi, I have this problem and would be interested in seeing the solution from the tar. Thank you for your help. Roy Armstrong [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Vergara, Michael (TEM) INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
