BIN$ objects (after media recovery)

From: Bob <bobmetelsky_at_comcast.net>
Date: Sun, 17 Jul 2005 09:48:56 -0400
Message-ID: <42DA61C8.6040205@comcast.net>

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?

eg
BOB_at_STAGE10>select * from cat;

TABLE_NAME                     TABLE_TYPE
------------------------------ -----------
BIN$Xob75zTpREqzMEwVrcT35Q==$0 TABLE
EMP2                        TABLE

BOB_at_STAGE10>desc BIN$Xob75zTpREqzMEwVrcT35Q==$0; SP2-0565: Illegal identifier.

BOB_at_STAGE10>drop table BIN$Xob75zTpREqzMEwVrcT35Q==$0; drop table BIN$Xob75zTpREqzMEwVrcT35Q==$0

                                      *

ERROR at line 1:
ORA-00933: SQL command not properly ended

BOB_at_STAGE10>drop table 'BIN$Xob75zTpREqzMEwVrcT35Q==$0'; drop table 'BIN$Xob75zTpREqzMEwVrcT35Q==$0'

            *
ERROR at line 1:
ORA-00903: invalid table name

TIA! 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."
--
http://www.freelists.org/webpage/oracle-l

Received on Sun Jul 17 2005 - 08:50:43 CDT