Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Partitioned tables

Re: Partitioned tables

From: Ricky Sanchez <rsanchez_at_more.net>
Date: Fri, 18 May 2001 15:31:15 GMT
Message-ID: <3B054088.9646DEAF@more.net>

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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US