Re: partition key from data dictionary

I know others have already answered your question but here is a simple query
that will often allow you to find the table yourself:

select table_name from dictionary where table_name like '%PART%';

Keith

> I am looking at dba_tab_partiitions and dba_part_tables and I don't see the
> actual partition key column list there. What view do I check>? I know I can
> use dbms_metadata. I am trying to find it in the data dictionary.
>


--
http://www.freelists.org/webpage/oracle-l

Other related posts: