FAQ
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

Search Discussions

  • Ram Srinivasan at Jul 28, 2008 at 6:13 pm
    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 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

Related Discussions

Discussion Navigation
viewthread | post
Discussion Overview
grouporacle-l @
categoriesoracle
postedJul 28, '08 at 5:50p
activeJul 28, '08 at 6:13p
posts2
users2
websiteoracle.com

People

Translate

site design / logo © 2022 Grokbase