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
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: 63911
Registered: March 2007
Location: Nanterre, France, http://...
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';

1 row selected.

SQL> col scn new_value scn
SQL> select dbms_flashback.get_system_change_number scn from dual;

1 row selected.

SQL> exec dbms_lock.sleep(30);

PL/SQL procedure successfully completed.

SQL> drop view v;

View dropped.

SQL> @sys

SYS> select text from sys.view$ as of scn &scn where obj# = &obj;
select "ID","NAM","TS" from t

1 row selected.

Previous Topic: Partitions
Next Topic: LOB
Goto Forum:

Current Time: Sun Oct 23 01:10:13 CDT 2016

Total time taken to generate the page: 0.07374 seconds