• Oracle Flashback Data Archive (FDA)

    --https://docs.oracle.com/en/database/oracle/oracle-database/19/adfns/flashback.html#GUID-06AA782A-3F79-4235-86D5-2D136485F093
    exec DBMS_FLASHBACK_ARCHIVE.SET_CONTEXT_LEVEL ('ALL');
    -- https://docs.oracle.com/en/database/oracle/oracle-database/19/sqlrf/CREATE-FLASHBACK-ARCHIVE.html#GUID-9E821EC5-8350-4729-85FE-2188EBB4139B

    --grant FLASHBACK ARCHIVE ADMINISTER to PRD;
    CREATE FLASHBACK ARCHIVE testarchive1
    TABLESPACE stofina
    RETENTION 1 YEAR;

    CREATE TABLE TEST
    FLASHBACK
    (
    CAMPO1 VARCHAR2(50)
    , CAMPO02DATE DATE
    , CAMPO03
    NUM NUMBER
    , CAMPO04CLOB CLOB
    );

    ALTER TABLE TESTFLASHBACK
    FLASHBACK ARCHIVE testarchive1;


    begin
    for i in 1 .. 500 loop
    insert into TEST
    FLASHBACK values ('ID: '||i,sysdate,i, sysdate||' campo clob '||i||user);
    update TESTFLASHBACK set CAMPO04CLOB = CAMPO04CLOB|| ' Update seq:'||i, CAMPO02DATE=CAMPO02DATE+i
    where CAMPO03
    NUM=i-1;
    commit;
    end loop;
    end;
    /
    select * from dbaFLASHBACKARCHIVETABLES ;

    select * from dbaFLASHBACKARCHIVETS;

    select * from dbaFLASHBACKARCHIVE;
    select * from TESTFLASHBACK as of timestamp sysdate - 1/24;

    select * from SYSFBAHIST312816;

    /* What between yesterday and now? /
    select DBMSFLASHBACKARCHIVE.getsyscontext(versionsxid, 'KLERSCONTEXT','USERNAME'),
    versions_endtime,
    a.

    from TESTFLASHBACK versions between timestamp todate( '24-jun-22 15:4200','dd-mon-yy hh24:miss') and sysdate a;

     

     

    Posted by Administrator.
© 2022 Financial step by step. All rights reserved.
Uncaught Exception

Uncaught Exception

Comments starting with '#' are deprecated in /php5.6/etc/php.ini on line 195

Origin

on line 0

Trace

#0 [internal function]: System\Error::shutdown()
#1 {main}