Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Partitioned tables
When you say "any object that is dependent on the table goes invalid", do you mean a persistent object? That is, do you have something like a foreign key dependency involved in this table? Or do you mean a non-persistent object - sql statement, pl/sql package or whatever?
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.
Received on Fri May 18 2001 - 10:31:15 CDT