| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Package becomes INVALID when a partiiton is dropped
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_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Deepak Sharma
Sent: Tuesday, June 28, 2005 12:52 PM
To: Eric List
Cc: oracle-l_at_freelists.org
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
> 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
>
-- http://www.freelists.org/webpage/oracle-l -- http://www.freelists.org/webpage/oracle-lReceived on Tue Jun 28 2005 - 13:07:37 CDT
 |
 |