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@xxxxxxxxxxx> 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

Other related posts: