Home » SQL & PL/SQL » SQL & PL/SQL » flashback query (oracle 9i)
flashback query [message #414019] Mon, 20 July 2009 02:38 Go to next message
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 Go to previous message
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
Previous Topic: Partitions
Next Topic: LOB
Goto Forum:
  


Current Time: Thu Feb 13 13:11:44 CST 2025