Create Flashback data archive tablespace

SQL> create tablespace FB_Storage datafile '/u01/oracle/oradata/orcl/fdstore.dbf' 
              size 100m autoextend on segment space management auto;


Step 2:- Create Flashback Archive

SQL> create flashback archive default FB_Arch1 tablespace FB_Storage quota 1g retention 1 year

Flashback archive created.



(i) Grant Flashback archive privilege 
SQL> grant flashback archive on fb_arch1 to scott;

Grant succeeded.

SQL> connect scott/tiger
(ii) Enable flashback archive for table
SQL> alter table emp flashback archive

Comments