Re: recyclebin
From: Sylvester, Peter A. <peters_at_mitre.org>
Date: Wed, 3 Jun 2009 10:39:16 -0400
Message-ID: <CA4A5C993E465A4292E14C850B2BBD2603CCD3B34D_at_IMCMBX1.MITRE.ORG>
There is no guarantee of retention for items in the recycle bin. If the space is needed for something it could get reused at any time, and certainly before the tablespace extension comes into play. There are supposedly some rules in place whereby Oracle attempts to reuse older objects first, but not sure it this is explicitly documented.
Date: Wed, 3 Jun 2009 10:39:16 -0400
Message-ID: <CA4A5C993E465A4292E14C850B2BBD2603CCD3B34D_at_IMCMBX1.MITRE.ORG>
There is no guarantee of retention for items in the recycle bin. If the space is needed for something it could get reused at any time, and certainly before the tablespace extension comes into play. There are supposedly some rules in place whereby Oracle attempts to reuse older objects first, but not sure it this is explicitly documented.
--Peter
--
http://www.freelists.org/webpage/oracle-l
Received on Wed Jun 03 2009 - 09:39:16 CDT