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
panyam
Messages: 146
Registered: May 2008
Senior Member
Hi All ,

SQL> select * from v$version;

BANNER
----------------------------------------------------------------
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Prod
PL/SQL Release 10.2.0.1.0 - Production
CORE    10.2.0.1.0      Production
TNS for 32-bit Windows: Version 10.2.0.1.0 - Production
NLSRTL Version 10.2.0.1.0 - 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  ;

PARTITION_NAME                 TABLE_NAME
------------------------------ ------------------------------
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: 64103
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.

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


Current Time: Sat Dec 03 06:15:36 CST 2016

Total time taken to generate the page: 0.04481 seconds