https://www.oracle.com/ocom/groups/public/@otn/documents/webcontent/4421812.pdf
--https://docs.oracle.com/en/database/oracle/oracle-database/19/adfns/flashback.html#GUID-06AA782A-3F79-4235-86D5-2D136485F093
exec DBMSFLASHBACKARCHIVE.SETCONTEXTLEVEL ('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 TESTFLASHBACK
(
CAMPO1 VARCHAR2(50)
, CAMPO02DATE DATE
, CAMPO03NUM NUMBER
, CAMPO04CLOB CLOB
);
ALTER TABLE TESTFLASHBACK
FLASHBACK ARCHIVE testarchive1;
begin
for i in 1 .. 500 loop
insert into TESTFLASHBACK values ('ID: '||i,sysdate,i, sysdate||' campo clob '||i||user);
update TESTFLASHBACK set CAMPO04CLOB = CAMPO04CLOB|| ' Update seq:'||i, CAMPO02DATE=CAMPO02DATE+i
where CAMPO03NUM=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;