Re: reclaiming space from recycle bin

As I am currently recovering a database to clone so as to retrieve a single row, I don't have time to look this up:

Does the recycle bin get purged automatically if the space is needed?

I know, I should already know that...

Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist Oracle Blog: http://jkstill.blogspot.com Home Page: http://jaredstill.com

On Wed, Dec 9, 2009 at 8:14 AM, Allen, Brandon <Brandon.Allen_at_oneneck.com>wrote:

> This is documented behavior:
>
>
>
>
> http://download.oracle.com/docs/cd/B19306_01/backup.102/b14192/flashptr004.htm#sthref615
>
>
>
> “Recycle bin objects are not counted as used space. If you query the space
> views to obtain the amount of free space in the database, objects in the
> recycle bin are counted as free space.”
>
>
>
> Regards,
>
> Brandon
>
>
>
> *From:* oracle-l-bounce_at_freelists.org [mailto:
> oracle-l-bounce_at_freelists.org] *On Behalf Of *Sharon.Kovac_at_Rotometrics.com
>
> There was no change in dba_free_space after I purged the recycle bin.
>
>
> ------------------------------
> Privileged/Confidential Information may be contained in this message or
> attachments hereto. Please advise immediately if you or your employer do not
> consent to Internet email for messages of this kind. Opinions, conclusions
> and other information in this message that do not relate to the official
> business of this company shall be understood as neither given nor endorsed
> by it.
>

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