How Oracle recovers stored procedures that are overwritten

If you accidentally overwrite the previous stored procedure, it's time to flash back, and the longer it is, the less likely it is to flash back. The principle is very simple, the definition of the stored procedure is a data dictionary, modify the data dictionary and modify the data of the ordinary table is not different, this time will be modified before the contents of the undo, we can according to this point to flash back, so I said to be as soon as possible, otherwise could not find back.

CREATE TABLE P_temp as

SELECT *

From Dba_source as of timestamp to_timestamp (' 2014-05-14 09:30:00 ', ' yyyy-mm-dd HH24:MI:SS ')

where TYPE = ' PROCEDURE '

and owner = ' dbsnmptest '

and Name = ' P_sc_mon ';

Select text

From P_temp

where Name = ' P_sc_mon ';

and owner = ' dbsnmptest '

Order by line;