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."
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?
-- //www.freelists.org/webpage/oracle-l