멀티 테넌트 컨테이너 데이터베이스에는 이러한 Oracle Flashback 기능을 사용할 수 없습니다. (CDB):
– For Oracle Database 12c Release 1 (12.1.0.1), Flashback Data Archive (FDA) is not supported in a CDB. For Oracle Database 12c Release 1 (12.1.0.2), this restriction is removed.
– Flashback Transaction Query is not supported in a CDB.
– Flashback Transaction Backout is not supported in a CDB.
|
1 2 3 4 5 6 7 8 9 10 11 12 13 |
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
https://docs.oracle.com/en/database/oracle/oracle-database/12.2/readm/features-not-available-12-2-beta.html#GUID-F3D717CD-13DA-408B-8FE8-43CABAD21B58