如果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存储过程》对你有帮助,请点赞、收藏,并留下你的观点哦!