That database now has undo_retention set to 86400 and an appropriate amount of UNDO space. The 900 second default isn't too useful when you get a call the next day... 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 11:01 AM, Niall Litchfield < niall.litchfield@xxxxxxxxx> wrote: > Also select * from .... As of timestamp is very useful. > > On 12/9/09, Niall Litchfield <niall.litchfield@xxxxxxxxx> wrote: > > It doesn't get purged, but space is eligible for reuse, so you can > > rely on getting that data back as many times as you like, until you > > actually need to when it will have been overwritten;-( > > > > On 12/9/09, Jared Still <jkstill@xxxxxxxxx> wrote: > >> 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. > >>> > >> > > > > -- > > Sent from my mobile device > > > > Niall Litchfield > > Oracle DBA > > http://www.orawin.info > > > > -- > Sent from my mobile device > > Niall Litchfield > Oracle DBA > http://www.orawin.info >