Practical Skills Sharing Restore Oracle's overwritten stored procedures

When writing or modifying a stored procedure, it is easy to run into a bit of caution, and the code behind it overwrites the previous stored procedure. How to recover, the quickest and most convenient method, Flash query!

1. Change the timestamp to before overwriting
CREATE TABLE Huifu_procedure as
SELECT *
From Dba_source as of timestamp to_timestamp (' 2014-11-26 14:00:00 ', ' yyyy-mm-dd HH24:MI:SS ')
where TYPE = ' PROCEDURE '
and owner = ' emply '
and Name = ' checkdata_2014emply ';

2. Locate the text, which is the code that is overwritten:
Select text from Huifu_procedure;

This article is from the "Hunter Oracle World" blog, so be sure to keep this source http://hunter8888.blog.51cto.com/1850277/1613785

Practical Skills Sharing Restore Oracle's overwritten stored procedures