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

注意：请使用DBA管理员用户进行操作

1.根据要找回的存储过程名查询出包头和包体的obj ID

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';

查询结果

63313

63314

2.查询旧版本数据

--查询出来的为包头

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

--查询出来的为包体

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