Partitioned tables

From: Scott Watson <swatson_at_datachest.com>
Date: Thu, 10 May 2001 19:07:07 GMT
Message-ID: <vFBK6.12360$yw.442785@news20.bellglobal.com>

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. Received on Thu May 10 2001 - 14:07:07 CDT