Re: Package becomes INVALID when a partiiton is dropped
- From: Jared Still <jkstill@xxxxxxxxx>
- To: sharmakdeep_oracle@xxxxxxxxx
- Date: Tue, 28 Jun 2005 00:52:02 +0100
The kernel is likely taking a ddl lock and updating DD
for the table and partition when the partition is dropped.
This would invalidate the procedure.
I have not built a test case, I have left that for you. :)
Jared
PS. Check the LAST_DDL_TIME column in the DBA_OBJECTS view
On 6/27/05, Deepak Sharma <sharmakdeep_oracle@xxxxxxxxx> wrote:
>
> I have a table, say T1, having 3 partitions P1, P2 and
> P3.
>
> There exists a PL/SQL procedure that declares
> variables as :
>
> col1 T1.col1%TYPE
>
> When I drop a partition P1 of table T1, the PL/SQL
> procedure becomes INVALID.
>
> The PL/SQL doesn't reference the partition P1 at all.
>
>
>
> ____________________________________________________
> Yahoo! Sports
> Rekindle the Rivalries. Sign up for Fantasy Football
> http://football.fantasysports.yahoo.com
> --
> //www.freelists.org/webpage/oracle-l
>
--
Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist
Other related posts:
