Re: reclaiming space from recycle bin
- From: Jared Still <jkstill@xxxxxxxxx>
- To: Brandon.Allen@xxxxxxxxxxx
- Date: Wed, 9 Dec 2009 10:36:51 -0800
Interesting, I did not recall that.
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@xxxxxxxxxxx>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@xxxxxxxxxxxxx [mailto:
> oracle-l-bounce@xxxxxxxxxxxxx] *On Behalf Of *Sharon.Kovac@xxxxxxxxxxxxxxx
>
> 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.
>
Other related posts:
