Re: How do I view what partition names are?

On 17 Jan 2005 11:19:19 -0800, rekaben_at_yahoo.com (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

General pointer:
the contents of the data dictionary can be seen in the view dict. In your case
select *
from dict
where table_name like '%PART%'

would have helped you out.

--
Sybrand Bakker, Senior Oracle DBA