more to the point, are the partitions all in the same tablespace?
--- John Weatherman <[EMAIL PROTECTED]> wrote: > 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). __________________________________ Do you Yahoo!? Exclusive Video Premiere - Britney Spears http://launch.yahoo.com/promos/britneyspears/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Rachel Carmichael 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).
