is has another name called Oracle total Recall , and its ability to track and store all transactional changes to a table over its lifetime.
How Can I Use it ?
create default flashback archive on an existing tablespace.
create flashback archive default tablespace retention ;
conn / a sysdba
SQL > create flashback archive default Osama tablespace User retention 1 year;
Create Table to Store Information inside it
Sql > Create table Store as select * from dba_objects; — For example
We Need to enable flash archive on same table by
Sql > alter table Store flashback archive;
-You need to check time by :
select systimestamp from dual;
– Check Created Point By
select timestamp_to_scn(systimestamp) from dual;
The Above is the main Steps To Enable FlashBack data Archive.