Re: partition table question.....

From: Howard J. Rogers <howardjr_at_www.com>
Date: Fri, 21 Sep 2001 03:43:42 +1000
Message-ID: <3baa2a1d@news.iprimus.com.au>

If you can't take a normal table offline (and you can't), you won't be able to take a table partition offline.

Doing it at the tablespace level is your only option, apart from (perhaps) exchanging a particular partition (temporarily) into a regular table, and exchanging it back again when you're ready.

Regards
HJR "Carl Mercer" <cmercer_at_vibrant-1.com> wrote in message news:d0bb6654.0109200343.267f2eb6_at_posting.google.com...
> > "Howard J. Rogers" <howardjr_at_www.com> wrote in message
news:<3ba94044_at_news.iprimus.com.au>...
> > > "Carl Mercer" <cmercer_at_vibrant-1.com> wrote in message

> .........

> > > I took a tablespace for one of the partitions offline. After which,
> > > selects against the table failed.

> .....

> >
> > It is. Provided that your select is not trying to access data in one of
the
> > offline partitions. Or that you don't have a global index which your
select
> > is using (since the entire index would be marked as unusable).
> >
> > The exact syntac escapes me, but to select directly from a partition
it's
> > something like select * from table partition (partition_name).

> .........
>

> > Regards
> > HJR

>
>
>
> Thanks
>
> My mistake... select count(*) from inventory fails, Duh!  I guess it
> was a silly question. Keep the DML out of the affected partitions and
> access to the table still works. I am also assuming that I can take
> partitions offline by taking the tablespace they are in offline. If
> there is a way to actually take just the partition offline, please let
> me know.  Also, you are right, the syntax for accessing individual
> partitions is "select count(*) from inventory (inv1);"
>
>
> Thanks for the reply.

Received on Thu Sep 20 2001 - 12:43:42 CDT