Re: partition key from data dictionary

From: Keith Moore <>
Date: Tue, 29 Jul 2008 16:24:08 -0500 (CDT)
Message-ID: <>

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.

Received on Tue Jul 29 2008 - 16:24:08 CDT

Original text of this message