flashback query - OracleConnections2024-03-28T20:42:33Zhttp://www.oracleconnections.com/forum/topics/flashback-query?commentId=6612035%3AComment%3A14714&feed=yes&xn_auth=noIn 10g.., Flash back will be…tag:www.oracleconnections.com,2013-06-19:6612035:Comment:143602013-06-19T07:05:46.872ZKara Scheiderhttp://www.oracleconnections.com/profile/KaraScheider
<p>In 10g..,<br/> Flash back will be enabled in mount stage by issuing cmd as</p>
<p>alter database flashback on;</p>
<p>then</p>
<p>alter database open;</p>
<p>you can check in</p>
<p>select flashback from v$database;</p>
<p>In 10g..,<br/> Flash back will be enabled in mount stage by issuing cmd as</p>
<p>alter database flashback on;</p>
<p>then</p>
<p>alter database open;</p>
<p>you can check in</p>
<p>select flashback from v$database;</p> Thanx, Keneth and Kara
Please…tag:www.oracleconnections.com,2013-06-19:6612035:Comment:143572013-06-19T07:04:26.625ZJohnson Groundshttp://www.oracleconnections.com/profile/JohnsonGrounds
<p>Thanx, Keneth and Kara</p>
<p>Please help me to use flashback feature in oracle11g<br/> how to configure?<br/> and for what purpose we are using?</p>
<p>Thanx, Keneth and Kara</p>
<p>Please help me to use flashback feature in oracle11g<br/> how to configure?<br/> and for what purpose we are using?</p> Thanks for correcting metag:www.oracleconnections.com,2013-06-19:6612035:Comment:143562013-06-19T07:03:23.337ZKara Scheiderhttp://www.oracleconnections.com/profile/KaraScheider
<p>Thanks for correcting me</p>
<p>Thanks for correcting me</p> Kara, you are describing flas…tag:www.oracleconnections.com,2013-06-19:6612035:Comment:147172013-06-19T07:02:22.999ZKeneth Braganhttp://www.oracleconnections.com/profile/KenethBragan
<p>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:<br></br> orcl> conn scott/tiger<br></br> Connected.<br></br> orcl> select count(*) from emp;</p>
<p>COUNT(*)<br></br> ----------<br></br> 14</p>
<p>orcl> delete from emp;</p>
<p>14 rows deleted.</p>
<p>orcl> commit;</p>
<p>Commit complete.</p>
<p>orcl> --what did the table look like ten minutes ago?<br></br> orcl> select…</p>
<p>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:<br/> orcl> conn scott/tiger<br/> Connected.<br/> orcl> select count(*) from emp;</p>
<p>COUNT(*)<br/> ----------<br/> 14</p>
<p>orcl> delete from emp;</p>
<p>14 rows deleted.</p>
<p>orcl> commit;</p>
<p>Commit complete.</p>
<p>orcl> --what did the table look like ten minutes ago?<br/> orcl> select count(*) from emp as of timestamp (systimestamp -10/1440);</p>
<p>COUNT(*)<br/> ----------<br/> 14</p>
<p>orcl> --so now I can repair the damage<br/> orcl> insert into emp select * from emp as of timestamp (systimestamp -10/1440);</p>
<p>14 rows created.</p>
<p>orcl> commit;</p>
<p>Commit complete.</p> Flash back is new feature in…tag:www.oracleconnections.com,2013-06-19:6612035:Comment:147142013-06-19T06:55:43.474ZKara Scheiderhttp://www.oracleconnections.com/profile/KaraScheider
<p>Flash back is new feature in ORACLE 10g,<br/> 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.</p>
<p>Ex:-Flash back table <table_name> before drop;</p>
<p>If table was deleted you get back by issuing above cmd you can get back from recycle bin.</p>
<p>Recyle bin information you will get in..<br/> show recylebin</p>
<p>or</p>
<p>user_recyclebin</p>
<p>Flash back is new feature in ORACLE 10g,<br/> 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.</p>
<p>Ex:-Flash back table <table_name> before drop;</p>
<p>If table was deleted you get back by issuing above cmd you can get back from recycle bin.</p>
<p>Recyle bin information you will get in..<br/> show recylebin</p>
<p>or</p>
<p>user_recyclebin</p>