[z] 利用閃回恢復被覆蓋的Oracle PACKAGE包

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;