ANBOB™

如果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;

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

打赏

微信扫一扫，打赏作者吧～