pardhu323

 Profile Answers by pardhu323 

• Jul 20th, 2008

 

Through flash back queries you can get the data which has been deleted permanently.

Different types of methods are there :

Use the following links to get the complete information :

http://download.oracle.com/docs/cd/B14117_01/appdev.101/b10795/adfns_fl.htm

http://it.toolbox.com/blogs/david/using-dbms_flashback-in-oracle-to-set-your-entire-session-back-in-time-14792

sububhaai

 Profile Answers by sububhaai 

• May 14th, 2009

 

Flash Back Query:
-----------------------

You perform a Flashback Query using a SELECT statement with an AS OF clause. You use a Flashback Query to retrieve data as it existed at some time in the past. The query explicitly references a past time using a timestamp or SCN. It returns committed data that was current at that point in time.

SELECT COL1, COL2... FROM <TABLE_NAME> AS OF TO_DATE('05/01/2009','MM/DD/YYYY');

javedans

 Profile Answers by javedans 

• Jul 8th, 2009

 

Flashback query is used to retrieve data, which is errantly deleted or updated in the database. Or we can say, we can see data prior to commit the data in the database.

Flashback only available in system managed undo database.

There are two method to retrieve data.
1. Enable_at_time
2. Enable_at_system_change_number

In built package for the same is
DBMS_FLASHBACK

psingla

 Profile Answers by psingla Questions by psingla

• May 7th, 2010

 

Flash Back queries are used to revert the commited chnages.
Non commited will be reverted automatically.

murthy 1053

 Profile Answers by murthy 1053 

• Jul 2nd, 2010

 

Flash back query is used to retrive the data.
For ex if a table is dropped and we want the table again so at that time.
syn:=FLASHBACK TABLE table_name TO BEFORE DROP.
This will work only if recycled bin is not purged.

Radha

• Jul 13th, 2011

 

Flash Back query is used to get back the deleted rows & dropped tables from the database even they are
committed.
To get back the dropped table:
Flashback table to before drop;
To get back the deleted rows even after commit:
Flashback table to timestamp
(systimestamp - interval '10' minute);