RE: Package becomes INVALID when a partiiton is dropped
- From: "Mercadante, Thomas F (LABOR)" <Thomas.Mercadante@xxxxxxxxxxxxxxxxx>
- To: <sharmakdeep_oracle@xxxxxxxxx>, "Eric List" <listeric1@xxxxxxxxx>
- Date: Tue, 28 Jun 2005 13:02:10 -0400
Deepak,
Something else you can do. Change your package so that it does not
*directly* depend on the table. You could use dynamic SQL to perform
your queries against the table. This way, Oracle does not know that the
package is related to the table and will not mark it as invalid.
Tom
-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Deepak Sharma
Sent: Tuesday, June 28, 2005 12:52 PM
To: Eric List
Cc: oracle-l@xxxxxxxxxxxxx
Subject: Re: Package becomes INVALID when a partiiton is dropped
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@xxxxxxxxx> 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
--
//www.freelists.org/webpage/oracle-l
--
//www.freelists.org/webpage/oracle-l
Other related posts:
