Data in the ORACLE Stored Procedure table is overwritten and restored.

The data in the ORACLE Stored Procedure table is overwritten and restored. The old Stored Procedure overwrites the new stored procedure. As a result, all the previously used functions are 0. Therefore, the stored procedure is restored by performing the following steps: log on to PL/SQL with the SYSDBA permission of sys. If you forget the sys password, you need to modify the SQL code C: \ Users \ zhouxq> sqlplus/nolog SQL * Plus: release 11.2.0.1.0 Production on Monday April 15 11:47:59 2013 Copyright (c) 1982,201 0, Oracle. all rights reserved. SQL> connect/as sysdba is connected. SQL> alter user sys identified by upay1234; the user has changed. After login, the SQL code select * from dba_source AS OF TIMESTAMP TO_TIMESTAMP ('2017-4-15 09:10:00 ', 'yyyy-MM-DD HH24: MI: ss ') where owner = 'uppa' and line> 1590 table data recovery first deletes the data in the table, and then runs the SQL code insert into s_module (mod_id, mod_name, mod_parent_id, mod_addr, mod_icon, mod_max_auth, mod_level) select * from s_module as of timestamp to_timestamp ('2017-04-15 09:20:00 ', 'yyyy-mm-dd hh24: mi: ss ');