Reputation: 11
When I did a select * from tab
in my schema, it showed all the tables along with few new tables which are not created by me. The names of the table are quit contradictory to oracle naming conventions. One of them is like BIN$BwCyfyRPTJMKYfRpcHhiuQ==$0
.
When I tried to drop them, it gave error invalid table name. I don't understand how did they got created in the first place. This is a local database of Oracle 10g. I doubt it as Virus. Please help how to get rid of these or I ll have to format my machine.
Upvotes: 1
Views: 339
Reputation:
Those are dropped tables that were moved to the recycle bin.
If you run
PURGE RECYCLEBIN;
then those tables will go away.
More details in the manual: http://docs.oracle.com/cd/E11882_01/server.112/e26088/statements_9018.htm#SQLRF01803
Upvotes: 3