Re: BIN$ objects (after media recovery)

Based on what I have understood, the objects remain in bin$ until oracle needs to allocate space but no free space is available. Then I think it starts with earliest dropped object.
 Raj

 On 7/18/05, Sinardy <all_about_oracle_at_hotpop.com> wrote:
>
> 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_at_gmail.com>
> To: <bobmetelsky_at_comcast.net>
> Cc: "oracle-l" <oracle-l_at_freelists.org>
> 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_at_comcast.net> 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
> >
>
>
>
> --
> http://www.freelists.org/webpage/oracle-l
>

-- 
------------------------------
select standard_disclaimer from company_requirements where category = 
'MANDATORY';

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