0 Replies Latest reply on Jul 25, 2019 2:50 PM by 981137

    can we flash back a table even when flash back is turned off ?

    981137

      dev1> select flashback_on from v$database;

       

       

      FLASHBACK_ON

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

      YES

       

       

      dev1> alter dtaba

       

       

      dev1>

      dev1>

      dev1> FLASHBACK TABLE DBAMAINT.TB_DHC_DIRECTORY TO TIMESTAMP TO_TIMESTAMP('2019/07/24 08:55:00', 'YYYY/MM/DD HH24:MI:SS');

      FLASHBACK TABLE DBAMAINT.TB_DHC_DIRECTORY TO TIMESTAMP TO_TIMESTAMP('2019/07/24 08:55:00', 'YYYY/MM/DD HH24:MI:SS')

                               *

      ERROR at line 1:

      ORA-08189: cannot flashback the table because row movement is not enabled

       

       

       

       

      dev1> alter table DBAMAINT.TB_DHC_DIRECTORY enable row movement;

       

       

      Table altered.

       

       

      dev1>  FLASHBACK TABLE DBAMAINT.TB_DHC_DIRECTORY TO TIMESTAMP TO_TIMESTAMP('2019/07/25 08:55:00', 'YYYY/MM/DD HH24:MI:SS');

       

       

      Flashback complete.

       

       

      dev1> alter database flashback off;

       

       

      Database altered.

       

       

      dev1> FLASHBACK TABLE DBAMAINT.TB_DHC_DIRECTORY TO TIMESTAMP TO_TIMESTAMP('2019/07/25 08:55:00', 'YYYY/MM/DD HH24:MI:SS');

       

       

      Flashback complete.

       

       

      dev1> FLASHBACK TABLE DBAMAINT.TB_DHC_DIRECTORY TO TIMESTAMP TO_TIMESTAMP('2019/07/25 08:55:00', 'YYYY/MM/DD HH24:MI:SS');

       

       

      Flashback complete.

       

       

      dev1> FLASHBACK TABLE DBAMAINT.TB_DHC_DIRECTORY TO TIMESTAMP TO_TIMESTAMP('2019/07/25 07:55:00', 'YYYY/MM/DD HH24:MI:SS');

       

       

      Flashback complete.

       

       

      dev1> FLASHBACK TABLE DBAMAINT.TB_DHC_DIRECTORY TO TIMESTAMP TO_TIMESTAMP('2019/07/23 07:55:00', 'YYYY/MM/DD HH24:MI:SS');

       

       

      Flashback complete.

       

       

      dev1> select flashback_on from v$database;

       

       

      FLASHBACK_ON

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

      NO

       

       

      dev1> alter database flashback on;

       

       

      Database altered.

       

       

      dev1> FLASHBACK TABLE DBAMAINT.TB_DHC_DIRECTORY TO TIMESTAMP TO_TIMESTAMP('2019/07/23 07:55:00', 'YYYY/MM/DD HH24:MI:SS');

       

       

      Flashback complete.

       

       

       

      Thanks

      Bhanu