멀티 테넌트 컨테이너 데이터베이스에는 이러한 Oracle Flashback 기능을 사용할 수 없습니다. (CDB):
– For Oracle Database 12c Release 1 (126.96.36.199), Flashback Data Archive (FDA) is not supported in a CDB. For Oracle Database 12c Release 1 (188.8.131.52), 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
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