Oracle 11g 閃迴歸檔

--建立一個新的表空間(注意段空間管理一定得是auto)

sys@TESTDB11>create tablespace fbtbs datafile '/oradata/fbtbs01.dbf' size 200m

  2  segment space management auto;

Tablespace created.

--建立flashback archive

sys@TESTDB11>create flashback archive fba1 tablespace fbtbs quota 150m retention 1 year;

Flashback archive created.

sys@TESTDB11>grant flashback archive on fba1 to scott;

Grant succeeded.

--將表與歸檔關聯起來

scott@TESTDB11>alter table dept flashback archive fba1;

Table altered.

--在建立表時將表與flashback archive直接關聯起來

scott@TESTDB11>create table test1(id number) flashback archive fba1;

Table created.

--斷開與flashback archive的關係

sys@TESTDB11>alter table scott.dept no flashback archive;

Table altered.

sys@TESTDB11>alter table scott.test1 no flashback archive;

Table altered.

scott@TESTDB11>drop table test1 purge;

Table dropped.