oracle找寻删除的存储过程方法

1.必须用DBA账号。

2.实现方法如下：

SELECT obj#
FROM obj$ AS OF TIMESTAMP TO_TIMESTAMP('2011-11-21 11:30:00', 'YYYY-MM-DD HH24:MI:SS')
WHERE NAME = ' PKG_QT_QTSWTS';

查询结果

264675
264676

2.查询旧版本数据

--查询出来的为包头

SELECT source FROM source$ AS OF TIMESTAMP TO_TIMESTAMP('2011-11-21 11:30:00', 'YYYY-MM-DD HH24:MI:SS') where obj# = 264675;

--查询出来的为包体

SELECT source FROM source$ AS OF TIMESTAMP TO_TIMESTAMP('2011-11-21 11:30:00', 'YYYY-MM-DD HH24:MI:SS') where obj# = 264676;