objects in the recycle bin are considered to be *free space* -- they will be used eventually. as soon as any object needs space in the same tablespace, and all "real" free space is gone, the recycle bin will automatically get purged.
kind regards,
Lex.
-- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- --- Steve Adams Seminar http://www.naturaljoin.nl/events/seminars.html -- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- --- -- --Original Message-- -- From: oracle-l-bounce@(protected) [mailto:oracle-l-bounce@(protected)] On Behalf Of Sinardy Sent: Monday, July 18, 2005 11:07 To: davidsharples@(protected); oracle-l Subject: Re: BIN$ objects (after media recovery)
Hi,
Do you know what happen if you continuously drop very big objects without bother to purge your bin? Will that hang the system until you purge those old objects or it is work like round robin.
regards, Sinardy
-- -- Original Message -- -- From: "David Sharples" <davidsharples@(protected)> To: <bobmetelsky@(protected)> Cc: "oracle-l" <oracle-l@(protected)> Sent: Sunday, July 17, 2005 9:52 PM Subject: Re: BIN$ objects (after media recovery)
> there are your recycle bin objects - purge recycle bin; to clear them > > > or drop table xxx purge; when you drop it oringially > > On 7/17/05, Bob <bobmetelsky@(protected)> wrote: > > win 2000 server - oracle 10.1 - archivelog mode > > > > Ive seen these object names before and research (goggle) suggested they > > were "recovered fragments" > > > > Ive just performed media recovery on a datafile and all objects in that > > datafile now seem to have a corresponding BIN$Xob75zTpRE..... > > name. > > > > What are these BIN$ objects and if they are useless how to get rid of them? > > > -- > http://www.freelists.org/webpage/oracle-l >
