Re: Any way to disable a partition?

On Mon, 05 Jul 2004 00:25:36 -0700, wy wrote:

>
> If I only make the tablespace offline,full table access will fail.
>
> Any suggestions?

Exchange partitions.

alter table eggs exchange partition omlet with table chicken;

If table chicken was empty before, it will contain all the data from partition omlet. Parition omlet will be emptied, much to the delight of this forum.

-- 
Well-behaved women seldom make history