Re: How do I view what partition names are?

RK wrote:

> Hi,
>
> I am not the DBA, and I can not find him anywhere. But I know the big
> tables are partitioned. My question is that how to find out what the
> partition names the DBA is using for partitioning the tables.
> Something like the following codes to find what tablenames are:
>
> select table_name from all_tables;
>
> Which table can I look for this info? Any help?
>
> Thanks.
>
> RK

Sybrand's advice plus ... go to http://www.psoug.org click on Morgan's Library
click on Partitions

at the top of the page is a listing of data dictionary tables and views that might be of interest.

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace 'x' with 'u' to respond)