Hi Kiran Pulibandla,
Check whether the following query is useful for your query:
===========================================================

SELECT table_name, partition_name partition, high_value,
partition_position position FROM user_tab_partitions WHERE
table_name=<TABLE_NAME>
order by position;

Rgds,
P.Ramesh


-----Original Message-----
From: kiran
[mailto:oracledba-ezmlmshield-x47050733.[Email address protected]
Sent: Tuesday, May 30, 2006 5:21 PM
To: LazyDBA Discussion
Subject: How to check the partitions for a table


Hello DBAs,

is there any query or table to check the partitions for a given table

please help me...

Thanks in advance

Kiran Pulibandla
Tata Consultancy Services Limited
International Tech Park,
Innovator, 11th Floor,
Whitefield Road,
Bangalore - 560066,Karnataka
India
Mailto: kiran.[Email address protected]
Website: http://www.tcs.com
=====-----=====-----=====
Notice: The information contained in this e-mail
message and/or attachments to it may contain
confidential or privileged information. If you are
not the intended recipient, any dissemination, use,
review, distribution, printing or copying of the
information contained in this e-mail message
and/or attachments to it are strictly prohibited. If
you have received this communication in error,
please notify us by reply e-mail or telephone and
immediately and permanently delete the message
and any attachments. Thank you




--------
website: http://www.LazyDBA.com
Please don't reply to RTFM questions
Oracle documentation is here: http://tahiti.oracle.com
To unsubscribe: see http://www.lazydba.com/unsubscribe.html
To subscribe: see http://www.lazydba.com
By using this list you agree to these
terms:http://www.lazydba.com/legal.html





Please note change in the sender's e-mail address and update your address
book accordingly.

+---------------------------------------------------------------------------
----------+
This message may contain confidential and/or privileged information. If you
have received this message in error, please advise the sender immediately by
reply e-mail and delete this message. If you are not the addressee or
authorized to receive this for the addressee, you must not use, copy,
disclose or take any action based on this message (except to notify the
sender) or any information herein. Thank you for your cooperation.

+---------------------------------------------------------------------------
----------+



Oracle LazyDBA home page