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