recyclebin for oracle 10g

show recyclebin --檢視回收站中的物件

drop table tableName purge; -- 刪除表不經過回收站

purge recyclebin; --清空回收站

select owner,object_name,original_name,operation,droptime from dba_recyclebin where object_name='&object_name'; --透過物件名稱查詢相關資訊

purge table "object_name"; --清空回收站中指定的物件[@more@]