Home » SQL & PL/SQL » SQL & PL/SQL » How to find the Range
How to find the Range [message #390640] Mon, 09 March 2009 02:05 Go to next message
Messages: 146
Registered: May 2008
Senior Member
Hi All ,

SQL> select * from v$version;

Oracle Database 10g Enterprise Edition Release - Prod
PL/SQL Release - Production
CORE      Production
TNS for 32-bit Windows: Version - Production
NLSRTL Version - Production

I have created a table ( Partitioned range based ).

My question is how can i find the maximun Range of my partiotioned table ?..i tried the below query ..

SQL> select partition_name , table_name from user_tab_partitions
  2  where table_name = 'LOGMNRC_GSII'
  3  ;

------------------------------ ------------------------------
P_LESSTHAN100                  LOGMNRC_GSII

I need to hav the range also on which the partiotions is based.

Thnks in advance
Sastry .P
Re: How to find the Range [message #390644 is a reply to message #390640] Mon, 09 March 2009 02:22 Go to previous message
Michel Cadot
Messages: 65088
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
dba_tab_partitions.high_value for each partition.
Same column where partition_position = max(partition_position) for the last one.

Previous Topic: Inserting More than 32,000 Characters to NCLOB field
Next Topic: optional condition in SQL
Goto Forum:

Current Time: Thu Jul 27 00:14:52 CDT 2017

Total time taken to generate the page: 0.97391 seconds