Querying a subpartition????

--=_MAILER_ATTACH_BOUNDARY1_2003540224728184803526 Content-Type: text/plain; charset=us-ascii

Hello friends,

                  I am a newbie in Oracle and just trying my hands on it. There is this very bugging problem that is driving me nuts.  I have created a table with subpartition, say three partition and two subpartitions in each partition. I can query the partition like

sql> select * from dummy partition (p1);

but I don't know how to query the subpartition.

please help.

And yes one more thing.

It is not possible to have both partitions and subpartitions to be partitioned by range. why????  

badly in need of help. and thanks in advance. Get Your Private, Free E-mail from Indiatimes at http://email.indiatimes.com Buy The Best In BOOKS at http://www.bestsellers.indiatimes.com Bid for Air Tickets @ Re.1 on Air Sahara Flights. Just log on to http://airsahara.indiatimes.com and Bid Now !

--=_MAILER_ATTACH_BOUNDARY1_2003540224728184803526 Content-Type: text/html; charset=us-ascii

<P>Hello friends,</P>
<P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; I am a newbie in Oracle and just trying my hands on it. There is this very bugging problem that is driving me nuts.&nbsp; I have created a table with subpartition, say three partition and two subpartitions in each partition. I can query the partition like</P>
<P>sql&gt; select * from dummy partition (p1);</P>
<P>but I don't know how to query the subpartition.</P>
<P>please help.</P>
<P>And yes one more thing.&nbsp; </P>
<P>It is not possible to have both partitions and subpartitions to be partitioned by range. why????</P>
<P>&nbsp;</P>
<P>badly in need of help. and thanks in advance.</P>
<hr><font face="Arial" size="2"><b>Get Your Private, Free E-mail from Indiatimes at </font>http://email.indiatimes.com</b><br>Buy The Best In <b>BOOKS</b> at http://www.bestsellers.indiatimes.com<br>Bid for <b>Air Tickets @ Re.1</b> on Air Sahara Flights. Just log on to http://airsahara.indiatimes.com and Bid Now !</font>

--=_MAILER_ATTACH_BOUNDARY1_2003540224728184803526--

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: amrozkamal
  INET: amrozkamal_at_indiatimes.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).