Table partitioning Oracle 9.2

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

RDBMS Version: 9.2.0.1.0
Operating System and Version: Solaris 8
Error Number (if applicable):
Product (i.e. SQL*Loader, Import, etc.): Partitioned Table Product Version: 9.2.0.1.0

Table partitioning

Hi,

I've a query reg. space usage in context of partitioned tables.

I've a table with 12 partitions P_1 ... P_12. Until now data got populated in P_1 upto P_6 and future data will come in P_7 etc. If i delete some huge amount of data from P_1 (after archiving it) will that freed space be used by future inserts (which happens in subsequent partitions like P_7 etc). Unfortunately, we can't delete all data in partition. We have to keep some data which account say 5% of total data. ie, we're deleting 95% of data from a partition. So, will this freed blocks be put to free list and used by future inserts? Data is partitioned by date. So, my query is whether Oracle will put future data (which belongs to partition P_7 etc.) in space earlier used by P_1.

Any help from members is appreciated.

Thanks,
Vikas

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 on Air Sahara Flights. For Best Deals, log on to http://airsahara.indiatimes.com and Bid Now !

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

<P><STRONG></STRONG>&nbsp;</P>
<P><STRONG>RDBMS Version</STRONG>: 9.2.0.1.0<BR><B>Operating System and Version</B>: Solaris 8<BR><B>Error Number (if applicable)</B>: <BR><B>Product (i.e. SQL*Loader, Import, etc.)</B>: Partitioned Table<BR><B>Product Version</B>: 9.2.0.1.0<BR><BR>Table partitioning<BR><BR>Hi, <BR><BR>I've a query reg. space usage in context of partitioned tables. <BR><BR>I've a table with 12 partitions P_1 ... P_12. Until now data <BR>got populated in P_1 upto P_6 and future data will come in P_7 etc. <BR>If i delete some huge amount of data from P_1 (after archiving it) <BR>will that freed space be used by future inserts (which happens in subsequent partitions like P_7 etc). <BR>Unfortunately, we can't delete all data in partition. We have to keep some data which account say 5% of total data. ie, we're deleting 95% of data from a partition. So, will this freed blocks be put to free list and used by future inserts? <BR>Data is partitioned by date. So, my query is whether Oracle will put fu!
tu!
re data (which belongs to partition P_7 etc.) in space earlier used by P_1.<BR><BR>Any help from members is appreciated. <BR><BR>Thanks, <BR>Vikas <BR></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</b> on Air Sahara Flights. For Best Deals, log on to http://airsahara.indiatimes.com and Bid Now !</font>

--=_MAILER_ATTACH_BOUNDARY1_2003103151337181540383426--

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