Re: Partitioned tables

Scott Watson wrote:
>
> I decided to partition a table based on a key that is used for deletes in
> thinking that when time came around
> to actually performing the delete I could just drop the partition. Well it
> was a nice thought however, the problem
> now is that any object that is dependant on the table goes invalid.
>
> This is a problem because client connection are maintained in a connection
> pool, therefore,
> all conections are opened at the startup of the app server. Now when a
> connection tries to call any of these
> objects that have gone invalid, it will fail. Do I have any options or do
> I have to go back to
> a regular table? ( I don't want to have to restart the app server )
>
> Thanks,
> Scott.

You could try wrapping the table in a view and issue an alter-view-compile as soon as you drop the partition...

hth
COnnor

-- 
===========================================
Connor McDonald
http://www.oracledba.co.uk (mirrored at
http://www.oradba.freeserve.co.uk)

"Some days you're the pigeon, some days you're the statue"