Re: BIN$ objects (after media recovery)

Thanks, I should have known it was the recycle $bin... Havent used it that much.

Thanks again
Bob

--

"Oracle error messages being what they are, do not
highlight the correct cause of fault, but will identify
some other error located close to where the real fault lies."


David Sharples wrote:
> 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