Re: partition key from data dictionary
Date: Tue, 29 Jul 2008 16:24:08 -0500 (CDT)
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%';
> 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.