What is flashback query in oracle 11G
what is the use of it

Views: 63

Reply to This

Replies to This Discussion

Flash back is new feature in ORACLE 10g,
Use: when ever if objects are Droped unexpectedly or by mistake(accidentally) then we can recover through SCN number or time of period we can recover.

Ex:-Flash back table <table_name> before drop;

If table was deleted you get back by issuing above cmd you can get back from recycle bin.

Recyle bin information you will get in..
show recylebin

or

user_recyclebin

Kara, you are describing flashback drop (which is based on renaming objects), not flashback query. Flashback query, introduced in 9i, uses undo segments and works like this:
orcl> conn scott/tiger
Connected.
orcl> select count(*) from emp;

COUNT(*)
----------
14

orcl> delete from emp;

14 rows deleted.

orcl> commit;

Commit complete.

orcl> --what did the table look like ten minutes ago?
orcl> select count(*) from emp as of timestamp (systimestamp -10/1440);

COUNT(*)
----------
14

orcl> --so now I can repair the damage
orcl> insert into emp select * from emp as of timestamp (systimestamp -10/1440);

14 rows created.

orcl> commit;

Commit complete.

Thanks for correcting me

Thanx, Keneth and Kara

Please help me to use flashback feature in oracle11g
how to configure?
and for what purpose we are using?

In 10g..,
Flash back will be enabled in mount stage by issuing cmd as

alter database flashback on;

then

alter database open;

you can check in

select flashback from v$database;

Reply to Discussion

RSS

Oracle Jobs in US

© 2024   Created by Maisam Agha.   Powered by

Badges  |  Report an Issue  |  Terms of Service