Flashback Query

===============

https://docs.oracle.com/cd/B28359_01/server.111/b28286/statements_9012.htm#SQLRF01802

=====================================

== Flashback Dropped table

=====================================

select * from dba_recyclebin;

FLASHBACK TABLE "ABMS"."BIN$hsZyomKSL6vgU8MBIgo32A==$0" TO BEFORE DROP RENAME TO WR80186_REFRESH_DATA_Orig;

FLASHBACK TABLE flashback_drop_test TO BEFORE DROP RENAME TO flashback_drop_test_old;

=====================================

== Method 1  Data as of 120 Min old  

=====================================

 

select

*

from abms.KSD_PROGRAM_BASIC

as of timestamp (systimestamp -interval '120' minute)

WHERE FK_CSB_CASE_NO IN (SELECT TRG_CASE_NUMBER FROM KEES62906_ISS_ST_DOC_ST_BLNK_U)

AND PROGRAM_TYPE = 'CC'

/

=====================================

=== Method 2

=====================================

create table abms.test22 as 

SELECT * FROM abms.sys_transact

AS OF TIMESTAMP TO_TIMESTAMP('02-SEP-2017 03:00:00', 'DD-MON-YYYY HH24:MI:SS');

create table akumar.KSD_PROGRAM_MONTH_FB as

select

/*+ parallel(KSD_PROGRAM_MONTH,5) */  *

from abms.KSD_PROGRAM_MONTH

as of timestamp (systimestamp -interval '120' minute)

WHERE FK_CSB_CASE_NO IN (SELECT TRG_CASE_NUMBER FROM KEES62906_ISS_ST_DOC_ST_BLNK_U)

AND FK_PGB_PROG_TYPE = 'CC';

/

=====================