一个有趣的测试

最新推荐文章于 2022-03-25 10:13:04 发布

lixora

最新推荐文章于 2022-03-25 10:13:04 发布

阅读量1.3k

点赞数 1

分类专栏：学习笔记

本文链接：https://blog.csdn.net/lixora/article/details/9288019

版权

学习笔记专栏收录该内容

204 篇文章 0 订阅

订阅专栏

SQL> show recyclebin
rows will be truncated

ORIGNAME_PLUS_SHOW_RECYC         OBJECTNAME_PLUS_SHOW_RECYC     OBJTYPE_PLUS_S
-------------------------------- ------------------------------ --------------
EMP_1                            BIN$0Q40up5pfKPgQAB/AQAbjg==$0 TABLE
TEST                             BIN$4MQeqBIB0bfgQAB/AQAnyw==$0 TABLE
TEST                             BIN$4MQeqBIA0bfgQAB/AQAnyw==$0 TABLE
SQL> create table test as select * from "BIN$4MQeqBIA0bfgQAB/AQAnyw==$0";

Table created.

SQL> show recyclebin
rows will be truncated

FILE_NAME
------------------------------------------------------------------------------
/u01/app/oracle/oradata/MYNEWDB/datafile/o1_mf_users_814jk5bg_.dbf
/u01/app/oracle/oradata/MYNEWDB/datafile/o1_mf_undotbs1_814jk569_.dbf
/u01/app/oracle/oradata/MYNEWDB/datafile/o1_mf_sysaux_814jk53d_.dbf
/u01/app/oracle/oradata/MYNEWDB/datafile/o1_mf_system_814jk4rs_.dbf
/u01/app/oracle/oradata/MYNEWDB/datafile/o1_mf_example_814jq4jj_.dbf

SQL> select * from test;
FILE_NAME
------------------------------------------------------------------------------
/u01/app/oracle/oradata/MYNEWDB/datafile/o1_mf_users_814jk5bg_.dbf
/u01/app/oracle/oradata/MYNEWDB/datafile/o1_mf_undotbs1_814jk569_.dbf
/u01/app/oracle/oradata/MYNEWDB/datafile/o1_mf_sysaux_814jk53d_.dbf
/u01/app/oracle/oradata/MYNEWDB/datafile/o1_mf_system_814jk4rs_.dbf
/u01/app/oracle/oradata/MYNEWDB/datafile/o1_mf_example_814jq4jj_.dbf

SQL>

至于为什么可以做跟recyclebin的工作原理有关

“The recycle bin is actually a data dictionary table containing information about
dropped objects. Dropped tables and any associated objects such as indexes,
constraints, nested tables, and the likes are not removed and still occupy space.”

recyclebin中对象只有在以下两情况下会真正清除物理文件：1、手工purge 2、表空间的空间大小约束，即空间不够的情况下oracle会自动清理其中对象。