Re: automatic purge of recycle bin

Yes. Unless you purge them, Oracle will leave objects in the recyclebin until the tablespace runs out of space, or until you hit your user quota on the tablespace. At that point, Oracle purges the objects one at a time, starting with the ones dropped the longest time ago, until there is enough space for the current operation. If the tablespace data files are AUTOEXTEND ON, Oracle will purge recyclebin objects before it autoextends a datafile.

Ram Srinivasan

On Mon, Jul 28, 2008 at 1:50 PM, Jeffrey Beckstrom <JBECKSTROM_at_gcrta.org>wrote:

> Will the recycle bin automatically be purged if the tablespace is full
> and another extent is requested?
>
>
> Jeffrey Beckstrom
> Database Administrator
> Greater Cleveland Regional Transit Authority
> 1240 W. 6th Street
> Cleveland, Ohio 44113
>

-- 
Sincerely
Ram Srinivasan

--
http://www.freelists.org/webpage/oracle-l