查看当前schema下的回收站对象
SELECT * FROM USER_RECYCLEBIN;
查看所有schema的回收站对象
SELECT * FROM DBA_RECYCLEBIN;
清空回收站下所有schema下的对象,需要Dba权限
PURGE DBA_RECYCLEBIN;
清空回收站下当前schema下的对象
PURGE RECYCLEBIN;
查看回收站使用大小
select sum(SPACE)*8/1024 Total_MB from dba_recyclebin;
查看回收站对象数
select count(*) from dba_recyclebin;