1.创建表空间
create tablespace flash_archive datafile '/oradata/cmsdb11g/flash_archive01.dbf' size 10M
autoextend on extent management local uniform size 1M segment space management auto;
2.创建flashback archive管理用户(需要授予用户flashback archive administer权限)
create user flashadm identified by flashadm
default tablespace flash_archive temporary tablespace temp quota unlimited on flash_archive;
grant create session to flashadm;
grant flashback archive administer to flashadm;
3.创建flashback archive
conn flashadm/flashadm
create flashback archive flash1 tablespace flash_archive quota 2000m retention 3 day;
select owner_name,flashback_archive_name,flashback_archive#,retention_in_days,status from dba_flashback_archive;
select * from dba_flashback_archive_ts;
4.开启表的flashback archive logging(需要授予用户flashback archive对象权限)
conn scott/tiger
alter table emp flashback archive flash1;
grant flashback archive on flash1 to scott;
alter table emp flashback archive flash1
5.相关视图
dba_flashback_archive_tables;
dba_flashback_archive_tables
dba_flashback_archive