Home » SQL & PL/SQL » SQL & PL/SQL » Oracle Partitioned Table get values (11G)
Oracle Partitioned Table get values [message #668603] Tue, 06 March 2018 12:48 Go to next message
Messages: 12
Registered: March 2018
Location: Madison, Wisconsin
Junior Member
Hi Team,

I am looking to obtain the details of partition value ranges for all partitioned oracle tables. I am able to obtain the other details but value ranges from DBA_TAB_PARTITIONS, DBA_PART_TABLES, DBA_SEGMENT etc.

Any suggestions much appreciated.

[Updated on: Tue, 06 March 2018 13:03]

Report message to a moderator

Re: Oracle Partitioned Table get values [message #668606 is a reply to message #668603] Tue, 06 March 2018 13:12 Go to previous message
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
Welcome to this forum

Please read and follow the forum guidelines, to enable us to help you:
OraFAQ Forum Guide
How to use {code} tags and make your code easier to read

Not all partitioned tables have "value ranges".
Available partitioning types:
Range partitioning (introduced in Oracle Cool
Hash partitioning (introduced in Oracle 8i)
Composite partitioning (introduced in Oracle 8i)
List partitioning (introduced in Oracle 9i)
Interval partitioning (introduced in Oracle 11g)
System partitioning (introduced in Oracle 11g)

"HIGH_VALUE LONG Partition bound value expression"
implicit is the idea that this partition minimum value is greater than the HIGH_VALUE of the preceding partition.

Previous Topic: help with error executing a view
Next Topic: Get Current & Previous Quarter Data from table
Goto Forum:

Current Time: Mon Jun 21 20:18:13 CDT 2021