DBA Hub

📋Steps in this guide1/1

Flashback a procedure/package

--- Like, tables ,If you have dropped or recreated a package/procedure, by using flashback ,we can get the proc code, before drop.

oracle configurationintermediate
by OracleDba
13 views
1

Flashback a procedure/package

get the object_id Now get the flashback code using timestamp

Code/Command (click line numbers to comment):

1
2
3
4
5
6
7
8
9
--- Like, tables ,If you have dropped or recreated a package/procedure, by using flashback ,we can get the proc code, before drop.
SQL>
select object_id from dba_objects where owner='DBACLASS' and object_name='VOL_DISCOUNT_INSERT';
OBJECT_ID
----------
2201943
select SOURCE from sys.source$ as of timestamp
to_timestamp('23-Apr-2017 10:00:20','DD-Mon-YYYY hh24:MI:SS')
where obj#=2201943 ;

Comments (0)

Please to add comments

No comments yet. Be the first to comment!