Replies to This Discussion

Permalink Reply by Kara Scheider on June 19, 2013 at 11:55am

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

• ▶ Reply

Permalink Reply by Keneth Bragan on June 19, 2013 at 12:02pm

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.

• ▶ Reply

Permalink Reply by Kara Scheider on June 19, 2013 at 12:03pm

Thanks for correcting me

• ▶ Reply

Permalink Reply by Johnson Grounds on June 19, 2013 at 12:04pm

Thanx, Keneth and Kara

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

• ▶ Reply

Permalink Reply by Kara Scheider on June 19, 2013 at 12:05pm

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

▶ Reply to Discussion