[Oracle 12c] 멀티테넌트 환경에서 Flashback Transaction Query 지원 불가


멀티 테넌트 컨테이너 데이터베이스에는 이러한 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.

 

 

 

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

 


Comments

comments

haisins

오라클 DBA 박용석 입니다. haisins@gmail.com 으로 문의 주세요.

댓글 남기기

이메일은 공개되지 않습니다. 필수 입력창은 * 로 표시되어 있습니다