ablog

不器用で落着きのない技術者のメモ

Oracle Database 10g で削除されたテーブルを確認する

set pagesize 50000
set linesize 300
col object_name for a30
col original_name for a30
col operation for a20
col type for a20
col droptime for a20

select object_name,original_name,operation,type, droptime from user_recyclebin
order by droptime, original_name;