Re: Package becomes INVALID when a partiiton is dropped

From: Deepak Sharma <sharmakdeep_oracle_at_yahoo.com>
Date: Tue, 28 Jun 2005 09:52:09 -0700 (PDT)
Message-ID: <20050628165209.41101.qmail@web31205.mail.mud.yahoo.com>

We are on 9.2.0.6 .

As you said, the package is actively being used when the DDL happens.

Right now I am manually co-ordinating with the application group so that I drop the partition(s) when the application is not running. After dropping I inform the group to run their application. This is a pain, as the table has about 180 daily partitions, and I need to do this every day.

Thanks,
Deepak

Eric List <listeric1_at_gmail.com> wrote:

> Deepak,
>
> It does not become clear which version of Oracle you
> are using.
> In the attached log it all seems OK when the package
> becomes invalid
> after partition manipulation. Like Thomas mentioned,
> the package will
> be recompiled next time it is used. A problem may
> arise when there
> is a session that is still actively using the
> package. That's whether
> you have a (potential) problem really depends on.
> Otherwise I
> wouldn't worry either.
>
> regards
> Eric Valk
>

Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com

--
http://www.freelists.org/webpage/oracle-l

Received on Tue Jun 28 2005 - 12:58:16 CDT