11.1 很不幸,此版本不支持DBMS_FLASHBACK_ARCHIVE
SQL > EXEC DBMS_FLASHBACK_ARCHIVE.DISASSOCIATE_FBA('scott','emp_test');
BEGIN DBMS_FLASHBACK_ARCHIVE.DISASSOCIATE_FBA('scott','emp_test'); END;
*
ERROR at line 1:
ORA-06550: line 1, column 7:
PLS-00201: identifier 'DBMS_FLASHBACK_ARCHIVE.DISASSOCIATE_FBA' must be declared
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored
11.2 正式推出DBMS_FLASHBACK_ARCHIVE,官方手册地址如下
Database PL/SQL Packages and Types Reference -> 70 DBMS_FLASHBACK_ARCHIVE
12.1 官方手册地址如下,和11.2相比位置做了调整
Database PL/SQL Packages and Types Reference -> 71 DBMS_FLASHBACK_ARCHIVE
但是该功能目前只支持传统方式的数据库,不支持CDB。看来要等到12.2了
FLASH_ADMIN@pdb1 > create flashback archive my_flash tablespace flash_tbs quota 50m retention 1 year;
create flashback archive my_flash tablespace flash_tbs quota 50m retention 1 year
*
ERROR at line 1:
ORA-65131: The feature Flashback Data Archive is not supported in a pluggable
database.
对于很想使用该功能的我处境比较尴尬。公司主要使用的数据库是10.2.0.17和12.1.0.1。 10G还没推出该功能,12目前不支持CDB。
等吧..
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/29047826/viewspace-1648942/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/29047826/viewspace-1648942/