Oracle-L: Re: Valid Packages/Procedures/Triggers that are NOT

From: mar666 mar666 <mas666dba_at_hotmail.com>
Date: Tue, 25 Nov 2003 12:09:26 -0800
Message-ID: <F001.005D7CAC.20031125120926@fatcity.com>

Hi Victoria

Are you sure that nobody alter some table or view include in these pkgs ??.

Mariano
Database Administrator.

>From: VICTORIA_PIERCE_at_rsausa.com
>Reply-To: ORACLE-L_at_fatcity.com
>To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
>Subject: Valid Packages/Procedures/Triggers that are NOT
>Date: Tue, 25 Nov 2003 11:34:29 -0800
>
>We had a weird situation yesterday on a database that had been upgraded
>from 8.1.6 to 9.2.0.1 over the weekend. Suddenly at 10:30 am, after being
>in production for a day and a half, 93 previously VALID packages, package
>bodies, triggers and procedures went INVALID. We have not been able to
>figure out what made them go invalid (they were all in the same
>application schema). Anyway, we recompiled all objects and all were then
>marked as VALID. However, some of the code still failed to work; (as an
>aside, we narrowed it down to those packages that contained ref cursors).
>Since the packages were apparently VALID, we did not recompile them again
>until after we bounced the database and generally chased our tails for a
>couple of hours. In a last-ditch effort, we recompiled all the objects
>again and the code started working.
>
>Do any of you know of a bug in 9i that would cause an INVALID package to
>be marked VALID? Or, when is a VALID package really INVALID?
>
>Thanks for your input.
>
>Vicki Pierce
>Database Administration
>x2401

Charla con tus amigos en línea mediante MSN Messenger: http://messenger.latam.msn.com/

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: mar666 mar666
  INET: mas666dba_at_hotmail.com

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: 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).

Received on Tue Nov 25 2003 - 14:09:26 CST