如果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;
都找回脚本了，怎么恢复不多说了，重建吧！
打赏
微信扫一扫，打赏作者吧～
如果觉得《oracle 存储过程误删 oracle恢复误删的procedure存储过程》对你有帮助，请点赞、收藏，并留下你的观点哦！
