3 Replies Latest reply: Oct 8, 2013 5:55 AM by a.aurel RSS

    Flashback Query

    a.aurel

      Hello,

       

           My database version: Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production

       

      select flashback_on from v$database;

      FLASHBACK_ON

      ------------------

      NO            

       

      But when i run this:

      my session: select count(*) from <my_table>

      -------------

      31336

       

      another session: delete from <my_table> where.... then commit

       

      my session:select count(*) from <my_table> as of TIMESTAMP to_timestamp('08.10.2013 10.00','dd.mm.yyyy hh24.mi')

      -----------

      186

       

       

       

      Why i have flashback if is not active?