有同事问我”BIN$Mp6ghZLX+d/gQAEKcwNPQA==$0“这些是什么来的。我一查询如下：
SQL> select owner,object_name,object_type from dba_objects where object_name like '%$Mp6ghZLX+d/gQAEKcwNPQA==$0%';
OWNER
------------------------------
OBJECT_NAME
--------------------------------------------------------------------------------
OBJECT_TYPE
-------------------
BLACK_BERRY2
BIN$Mp6ghZLX+d/gQAEKcwNPQA==$0
TABLE
是表，属于BLACK_BERRY2这个用户，但执行查询抛异常：
SQL> select * from BIN$Mp6ghZLX+d/gQAEKcwNPQA==$0;
select * from BIN$Mp6ghZLX+d/gQAEKcwNPQA==$0 *
ERROR at line 1:
ORA-00911: invalid character
细一看怎么觉得这些表名好熟悉呀。问是否是10g的数据库，回答是！呵呵，flashback！
SQL> show recyclebin
ORIGINAL NAME RECYCLEBIN NAME OBJECT TYPE DROP TIME
---------------- ------------------------------ ------------ -------------------
FOREX_BASICEXCHR BIN$Mp6ghZLX+d/gQAEKcwNPQA==$0 TABLE 2007-06-12:11:21:42
相关语法如下：
FLASHBACK TABLE XXX TO BEFORE DROP;
PURGE RECYCLEBIN;
DROP TABLE XXX PURGE;
PURGE TABLE XXX;
PURGE TABLE BIN$Mp6ghZLX+d/gQAEKcwNPQA==$0;
等等。。。
[@more@]来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/38542/viewspace-926276/ ，如需转载，请注明出处，否则将追究法律责任。
-
博文量235
-
访问量1707884
最新文章
- Two errors after cloning eBS
- An error from listener
- How to change the APPS db password in Oracle EBS
- Management on database link
- Three ways to quickly login into EBS 11i
- SMART Goal Setting
- A good template email on how to apply for training program
- 4C
- My understanding of AD configuration
- Taught Oracle database OCP training course
