查看当前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;