SQL> drop procedure "test123";
Procedure dropped
SQL> drop procedure "test";
Procedure dropped
如上我已经删除了procedure test123,test
现在我想找回已经删除的procedure,可以通过如下语句获得:
其查询方式和查询表里面删除的记录的方式一样。
select * from dba_source as of timestamp to_timestamp('2014-02-12 10:33:00', 'YYYY-MM-DD HH24:MI:SS') where owner='WLCSP' and type='PROCEDURE'
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/24237320/viewspace-1080059/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/24237320/viewspace-1080059/