Re: partition table question.....

> "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 - 06:43:27 CDT