Recover deleted procedure

Recover deleted procedure

Example :-

 
SQL> select text from dba_source where name='XXXX' order by line;
TEXT
--------------------------------------------------------------------------------
PACKAGE      XXXX
PACKAGE BODY      XXXX
AS
AS
 PROCEDURE XXXX(
   PROCEDURE XXXX (retcode            OUT VARCHAR2,
      retcode               OUT      VARCHAR2,
                                         errbuff            OUT VARCHAR2,
8 rows selected.


SQL> drop procedure upd_sales;
Procedure dropped.

SQL> connect / as sysdba
Connected.

SQL> select text from dba_source as of timestamp systimestamp - interval '60' minute where name='XXXX' order by line;

TEXT

--------------------------------------------------------------------------------
PACKAGE      XXXX
PACKAGE BODY      XXXX
AS
AS
 PROCEDURE XXXX(
   PROCEDURE XXXX (retcode            OUT VARCHAR2,
      retcode               OUT      VARCHAR2,
                                         errbuff            OUT VARCHAR2,
8 rows selected.

No comments:

Post a Comment