Vikas, Are you asking if deallocated extent space can be reused by the "current" partition or wether new dates will suddenly go into a partition that explicitly excludes them?
John P Weatherman Oracle Database Administrator Replacements, Ltd. -----Original Message----- Sent: Friday, October 31, 2003 3:24 AM To: Multiple recipients of list ORACLE-L --=_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> </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><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.indiatimes.com</A><br>Bid for <b>Air Tickets</b> on Air Sahara Flights. For Best Deals, log on to <a href="http://airsahara.indiatimes.com";>http://airsahara.indiatimes.com</a> and Bid Now !</font> --=_MAILER_ATTACH_BOUNDARY1_2003103151337181540383426-- -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Vikas S INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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: John Weatherman INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
