RE: Invalid objects

From: Bert van der Plas <bvanderplas_at_hmc-heerema.com>
Date: Thu, 19 Oct 2000 08:16:42 +0200
Message-Id: <10653.119737@fatcity.com>

As of Oracle 8, a scripts UTLRP.SQL (in directory RDBMS8\ADMIN) which compiles all invalid objects.

-----Original Message-----
From: Ron Rogers [mailto:RROGERS_at_galottery.org] Sent: Wednesday, October 18, 2000 9:16 PM To: Multiple recipients of list ORACLE-L Subject: Re: Invalid objects

recompile them would be the first step. If they failed to compile = review the
dba_errors table. Why did they become invalid? Was the tables dropped = and
then recreated that are used by the package? ROR =AA=BF=AA
>>> cemail_at_sprintmail.com 10/18/00 01:55PM >>>

How can you fix invalid stored procedures?

Sent using MailStart.com ( http://MailStart.Com/welcome.html ) The FREE way to access your mailbox via any web browser, anywhere!

--=20
Please see the official ORACLE-L FAQ: http://www.orafaq.com=20 --=20
Author:=20
INET: cemail_at_sprintmail.com=20

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (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).

--=20
Please see the official ORACLE-L FAQ: http://www.orafaq.com --=20
Author: Ron Rogers
INET: RROGERS_at_galottery.org

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------