oracle 闪回 找回 过程、触发器，包等 数据

一不小心create or replace覆盖的PL/SQL对象，结果就悲剧了
数据
select * from   rb_moduleaction  AS OF TIMESTAMP  (SYSTIMESTAMP - INTERVAL '10' MINUTE)


找回方法：
使用PLSQL用SYS，角色选择SYSDBA登录，新建Command窗体。输入时间点即可。
select text from dba_source as of timestamp to_timestamp('2012-12-05','yyyy-mm-dd')
    where name='TR_BIZ_XMZF' order by line;


SELECT *
  FROM DBA_SOURCE AS OF TIMESTAMP TO_TIMESTAMP('2009-03-18 10:07:00', 'YYYY-MM-DD HH24:MI:SS')
WHERE OWNER = 'USER'
   AND NAME = 'PRO_UPDATE_TB_USER_LOGIN'
--AND TYPE = 'PROCEDURE'
ORDER BY LINE


以下是一些很资料。
http://www.oracledatabase12g.com/archives/restore-replaced-plsql-objects.html

http://gaobo424.iteye.com/blog/1344678

http://blog.csdn.net/zlj113/article/details/5075983