OraFAQ Forum: SQL & PL/SQL » How to identify the partition type

Home » SQL & PL/SQL » SQL & PL/SQL » How to identify the partition type (Oracle 11)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

How to identify the partition type [message #655158]

Tue, 23 August 2016 03:59

saipradyumn
Messages: 419
Registered: October 2011
Location: Hyderabad

Senior Member

Hi All ,

How to identify the partition type of a table from data dictionary views?
USER_TAB_PARTITIONS gives the information weather the partitioned or not.
But I want to know the partition type like LIST , HASH , RANGE ..
Is these any way to find out the partition type ?

Thanks
SaiPradyumn

Report message to a moderator

Re: How to identify the partition type [message #655159 is a reply to message #655158]

Tue, 23 August 2016 04:03

John Watson
Messages: 9002
Registered: January 2010
Location: Global Village

Senior Member

dba_part_tables

Report message to a moderator

Re: How to identify the partition type [message #655162 is a reply to message #655159]

Tue, 23 August 2016 04:14

saipradyumn
Messages: 419
Registered: October 2011
Location: Hyderabad

Senior Member

Thank a lot

Report message to a moderator

Re: How to identify the partition type [message #655285 is a reply to message #655162]

Fri, 26 August 2016 01:45

saipradyumn
Messages: 419
Registered: October 2011
Location: Hyderabad

Senior Member

Hi John ,

Thanks for your answer.
How to identify the partition column. I mean on which column partition was applied .

Thanks
SaiPRadyumn

Report message to a moderator

Re: How to identify the partition type [message #655290 is a reply to message #655285]

Fri, 26 August 2016 02:15

Michel Cadot
Messages: 68776
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

ALL_PART_KEY_COLUMNS

Report message to a moderator

Re: How to identify the partition type [message #655296 is a reply to message #655290]

Fri, 26 August 2016 02:46

saipradyumn
Messages: 419
Registered: October 2011
Location: Hyderabad

Senior Member

Thanks Mike

Report message to a moderator

Previous Topic:	Minus Minutes
Next Topic:	Selective count with a condition

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu May 21 15:58:01 CDT 2026