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. >