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;

ITPub博客

[z] 利用闪回恢复被覆盖的Oracle PACKAGE包