flashback query [message #414019] |
Mon, 20 July 2009 02:38  |
ramesha
Messages: 6 Registered: July 2009
|
Junior Member |
|
|
By using Flash back Query can we get droped views,synonyms (or )sequences.
|
|
|
Re: flashback query [message #414028 is a reply to message #414019] |
Mon, 20 July 2009 02:53  |
 |
Michel Cadot
Messages: 68737 Registered: March 2007 Location: Saint-Maur, France, https...
|
Senior Member Account Moderator |
|
|
Yes it is possible if you have the privilege to do it...
SQL> create or replace view v as select * from t;
View created.
SQL> col object_id new_value obj
SQL> select object_id from user_objects where object_name = 'V';
OBJECT_ID
----------
61768
1 row selected.
SQL> col scn new_value scn
SQL> select dbms_flashback.get_system_change_number scn from dual;
SCN
----------
6233055
1 row selected.
SQL> exec dbms_lock.sleep(30);
PL/SQL procedure successfully completed.
SQL> drop view v;
View dropped.
SQL> @sys
Connected.
SYS> select text from sys.view$ as of scn &scn where obj# = &obj;
TEXT
------------------------------------------------------------
select "ID","NAM","TS" from t
1 row selected.
Regards
Michel
|
|
|