How to recover Oracle stored procedures with the same name after being overwritten

1. Log in to SYSDBA database

2. Querying snapshots based on point-in-time

SELECT * from source$ as of TIMESTAMP to_timestamp (' 2014-02-24 05:10:32 ', ' yyyy-mm-dd HH24:MI:SS ') where source like '%CP _eas_costbreakdown_info% '; (Cp_eas_costbreakdown_info is the name of the stored procedure)

3. Then query the code according to ojb#

SELECT * from source$ as of TIMESTAMP to_timestamp (' 2014-02-24 05:10:32 ', ' yyyy-mm-dd HH24:MI:SS ') where obj#=164283 Orde R by Line;

4, copy the source, a little adjustment to get it done

How to recover (GO) after Oracle stored procedure with the same name is overwritten