oracle的recycle功能

kevinlee0755

转自 http://topic.csdn.net/u/20100602/19/5e8f6bb9-f619-4cb4-a8ca-3e61323ed433.html1.show parameter recycle2.关闭回收alter system set recyclebin=off (默认on)alter session set recyclebin=off3.查看回收show recycle;select original_name,object_name from recyclebin;//查名字select * from "BIN$RWXQQcTPRde0ws4h9ewJcg==$0";4.清空purge tablespace tablespace_name (user user_name);purge recyclebin; --当前用户的purge dba_recyclebin --所有(dba权限)drop table name purge;(不能flashback恢复)purge index recycle_bin_object_name;(释放其索引--缓解空间压力的折中方案)