Re: Querying a subpartition????

Yes, you cannot query a subpartition. The reason for that is that subpartitions from the data contents point of view are not significant: rows are almost randomly (i.e. according to the hash function) spread across hash partitions - i.e. sub-partitions. As opposed to that, range partitions split the data according to a data dependent rule: e.g. all the rows where the date column is in a certain range go into one partition.

It does not make a lot of sense to have both partitions and sub-partitions range partitioned, as the two range partitioning criterions can be combined in one. Hash partitions were introduced to "randomly" split data accross multiple partitions, and so usually accross multiple data files / disks.

Djordje

• Original Message ----- To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com> Sent: Sunday, May 04, 2003 2:11 PM

> --=_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&gt; 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><a href="http://email.indiatimes.com"><font face="Arial" size="2">http://email.indiatimes.com</a></b><br>Buy The Best In <b>BOOKS</b> at <A
href="http://www.bestsellers.indiatimes.com">http://www.bestsellers.indiatim es.com</A><br>Bid for <b>Air Tickets @ Re.1</b> on Air Sahara Flights. Just log on to <a
href="http://airsahara.indiatimes.com">http://airsahara.indiatimes.com</a> 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).
>

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Djordje Jankovic
  INET: djordjej_at_rogers.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).