멀티 테넌트 컨테이너 데이터베이스에는 이러한 Oracle Flashback 기능을 사용할 수 없습니다. (CDB):
– For Oracle Database 12c Release 1 (220.127.116.11), Flashback Data Archive (FDA) is not supported in a CDB. For Oracle Database 12c Release 1 (18.104.22.168), this restriction is removed.
– Flashback Transaction Query is not supported in a CDB.
– Flashback Transaction Backout is not supported in a CDB.
SQL> conn system/oracle@pdb2 Connected. SQL> select count(*) from flashback_transaction_query; select count(*) from flashback_transaction_query * ERROR at line 1: ORA-01295: DB_ID mismatch between dictionary USE_ONLINE_CATALOG and logfiles
Features Not Available or Restricted for a Multitenant Container Database in Oracle Database 12c Release 2 (12.2)
The following is a list of features that are not available or are restricted for a multitenant container database (CDB):
- Flashback Transaction Query (in both local undo mode and shared undo mode)
- Database Recovery Advisor
- Oracle Sharding