BIN$ objects (after media recovery) 2005-07-17 - By Bob
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@(protected)>select * from cat;
TABLE_NAME TABLE_TYPE
-- ---- ---- ---- ---- ---- -- -- ---- ---
BIN$Xob75zTpREqzMEwVrcT35Q==$0 TABLE
EMP2 TABLE
BOB@(protected)>desc BIN$Xob75zTpREqzMEwVrcT35Q==$0;
SP2-0565: Illegal identifier.
BOB@(protected)>drop table BIN$Xob75zTpREqzMEwVrcT35Q==$0;
drop table BIN$Xob75zTpREqzMEwVrcT35Q==$0
*
ERROR at line 1:
ORA-00933 (See ORA-00933.ora-code.com): SQL command not properly ended
BOB@(protected)>drop table 'BIN$Xob75zTpREqzMEwVrcT35Q==$0';
drop table 'BIN$Xob75zTpREqzMEwVrcT35Q==$0'
*
ERROR at line 1:
ORA-00903 (See ORA-00903.ora-code.com): 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
|
|
