首页 » ORACLE » oracle恢复误删的procedure存储过程

oracle恢复误删的procedure存储过程

如果10分钟不小心刚刚误删了一个procedure,又没保存脚本,现在如何恢复? drop procedure必然delete dba_source,delete 当然会想到闪回查询

sql>conn test/test

sql>drop procedure p_user;

SQL> select text,name from dba_source where owner=’TEST’ and name=’P_USER’;

no rows selected

SQL> select text from dba_source AS OF TIMESTAMP SYSDATE-15/60/24 where owner=’TEST’ and name=’P_USER’;

TEXT
————————————————–
procedure p_user
is
begin
insert into test_pro(id,name,insertdate) values(us
erenv(‘SESSIONID’),user,sysdate);

end;

都找回脚本了,怎么恢复不多说了,重建吧!

打赏

目前这篇文章有1条评论(Rss)评论关闭。

  1. Merle Bialke | #1
    2011-12-21 at 12:55

    Hello! I could have sworn I’ve been to this weblog prior to but right after browsing through some of the post I realized it’s new to me. Anyways, I’m surely happy I found it and I’ll be book-marking and checking back regularly!