https://docs.oracle.com/cd/F19136_01/adfns/flashback.html#GUID-06AA782A-3F79-4235-86D5-2D136485F093
select
supplemental_log_data_min,
supplemental_log_data_pk,
supplemental_log_data_fk
from v$database;
alter database add supplemental log data;
sqlplus sys/oracle@pdb11 as sysdba
drop user test cascade;
create user test identified by test;
grant dba to test;
grant flashback any table to test;
grant SELECT ANY TRANSACTION to test;
sqlplus test/test@pdb11
alter table employee no flashback archive;
drop flashback archive fla1;
CREATE FLASHBACK ARCHIVE fla1 TABLESPACE users
QUOTA 1G RETENTION 1 YEAR;
drop table employee purge;
CREATE TABLE employee (EMPNO NUMBER(4) NOT NULL, ENAME VARCHAR2(10),
JOB VARCHAR2(9), MGR NUMBER(4)) FLASHBACK ARCHIVE fla1;
exec DBMS_FLASHBACK_ARCHIVE.SET_CONTEXT_LEVEL ('ALL');
commit;
select * from dba_FLASHBACK_ARCHIVE;
select * from dba_FLASHBACK_ARCHIVE_ts;
select * from dba_FLASHBACK_ARCHIVE_tables;
insert into employee values(1,'a','a',123);
insert into employee values(2,'a','a',123);
update employee set empno=empno+1;
commit;
insert into employee values(1,'a','a',123);
insert into employee values(2,'a','a',123);
update employee set empno=empno+1;
commit;
SELECT versions_xid XID, versions_startscn START_SCN,
versions_endscn END_SCN, versions_operation OPERATION,
EMPNO, ENAME
FROM employee
VERSIONS BETWEEN SCN MINVALUE AND MAXVALUE
;
select DBMS_FLASHBACK_ARCHIVE.GET_SYS_CONTEXT (versions_xid, 'USERENV', 'SESSION_USER'),
EMPNO, ENAME
FROM employee
VERSIONS BETWEEN SCN MINVALUE AND MAXVALUE
where versions_xid is not null
;
