oracle 通过快照找回误删除的存储过程

通过oracle快照从存储过程视图dba_source 中恢复被drop或者恢复修改前的存储过程

SELECT *
  FROM dba_source AS OF TIMESTAMP to_timestamp('2020-01-19 09:30:00', 'YYYY-MM-DD HH24:MI:SS')
 WHERE owner = ''--用户名
       AND NAME = '' --	包名

演示

SELECT *
  FROM dba_source AS OF TIMESTAMP to_timestamp('2020-01-19 09:30:00', 'YYYY-MM-DD HH24:MI:SS')
 WHERE owner = 'SYS'
       AND NAME = 'AGGXMLIMP' ;