drop table purge
来源:互联网 发布:淘宝服务端数据为空 编辑:程序博客网 时间:2024/05/16 12:25
Oracle官方文档:Oracle Database SQL Language Reference
PURGE
Specify PURGE
if you want to drop the table and release the space associated with it in a single step. If you specify PURGE
, then the database does not place the table and its dependent objects into the recycle bin.
Caution:
You cannot roll back aDROP
TABLE
statement with the PURGE
clause, nor can you recover the table if you have dropped it with the PURGE
clause.Using this clause is equivalent to first dropping the table and then purging it from the recycle bin. This clause lets you save one step in the process. It also provides enhanced security if you want to prevent sensitive material from appearing in the recycle bin.
-------------------------------------
1、drop table zml后,zml表被放入recycle bin.可以通过flashback table zml to before drop恢复drop掉的表,表中数据也可以被恢复。
2、drop table zml purge后zml表被直接删除,不可恢复
--------实例:----------
---------------drop table zml-------------------------SQL> show parameter recycle;NAME TYPE VALUE------------------------------------ ----------- ------------------------------buffer_pool_recycle stringdb_recycle_cache_size big integer 0recyclebin string on---SQL> purge recyclebin;回收站已清空。SQL> show recyclebin;SQL> create table zml(id int);表已创建。SQL> insert into zml values(1);已创建 1 行。SQL> drop table zml;表已删除。SQL> show recyclebin;ORIGINAL NAME RECYCLEBIN NAME OBJECT TYPE DROP TIME---------------- ------------------------------ ------------ -------------------ZML BIN$2cOZCZj0Ry27btpd7ymTHg==$0 TABLE 2014-04-23:21:56:58SQL> flashback table zml to before drop;闪回完成。SQL> select * from zml; ID---------- 1SQL>-----------------drop table zml1 purge-------------------------SQL> show recyclebin;SQL> create table zml1(id int);表已创建。SQL> insert into zml1 values(2);已创建 1 行。SQL> drop table zml1 purge;表已删除。SQL> show recyclebin;SQL>
- drop table purge
- drop table tablename purge
- oracle 数据库中 drop table 与purge
- Oracle tips:drop table和purge
- Oracle Drop表并未直接删除 drop table xx purge
- Oracle Drop表并未直接删除 drop table xx purge
- Oracle10g 回收站及彻底删除table : drop table xx purge
- Oracle10g 回收站及彻底删除table : drop table xx purge
- Oracle10g 回收站及彻底删除table : drop table xx purge
- Oracle Purge drop
- Oracle drop与purge区别
- move table and purge table
- Oracle Purge和drop的区别
- Oracle Purge和drop的区别
- Oracle Purge 和 Drop 的区别
- Oracle Purge和drop的区别
- Oracle Purge和drop的区别
- 怎么purge 已经被drop 的对象
- 第九周上机实践项目——更自然实现复数类中的运算符重载
- 第九章——<<>>的重载 (额这是怎么回事)
- Ubuntu 14.04 使用VirtualBox 4.3.10 虚拟 Windows 7
- HDU 1392 Surround the Trees(纯裸的凸包)
- makefile missing separator
- drop table purge
- TF-IDF(term frequency–inverse document frequency)
- kindle touch 修复
- cocos2dx引擎架构图
- 如何让UIView不停旋转
- AWR中的SQL Statistics
- HTTP中的重定向和请求转发的区别
- 迷茫,才是青春应该有的样子
- 802.11n关键技术