Re: Retrieving partitioning information

There are several views you can query to see how your partitioning is set up.
The one you are looking for is (assuming you do not have subpartitions)

DBA_PART_KEY_COLUMNS To get a list of the DBA partitioning dictionary views try:

select view_name from dba_views
where view_name like 'DBA%PART%';

Best of luck:

Stephen C. Ashmore
Brainbench MVP for Oracle Administration http://www.brainbench.com

Author of: 'So You Want to be an Oracle DBA?'

"Yash" <yash_ganthe_at_hotmail.com> wrote in message news:al1nf4$t4d$1_at_news.vsnl.net.in...
> Hi,
> Can I query any view from the data dictionary to find out the partitioning
> key(s) of a table and their order in the partitioning column list ?
>
> Thanks
> Yash
>
>
Received on Tue Sep 03 2002 - 05:30:49 CDT