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