SQL> create tablespace FB_Storage datafile '/u01/oracle/oradata/orcl/fdstore.dbf'
size 100m autoextend on segment space management auto;
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.
Flashback archive created.
(i) Grant Flashback archive privilege
SQL> grant flashback archive on fb_arch1 to scott;
Grant succeeded.
SQL> connect scott/tiger
Grant succeeded.
SQL> connect scott/tiger
(ii) Enable flashback archive for table
SQL> alter table emp flashback archive
Comments
Post a Comment