Oracle 23c: Managing Flashback Database Logs Outside the Fast Recovery Area
Overview: In previous Database releases, you could store flashback database logs only in the fast recovery area Oracle 23c Database introduces the ... Read More
Apprenez-en plus sur les raisons pour lesquelles Eclipsys a été certifié comme un excellent lieu de travail au Canada, les meilleurs lieux de travail en Ontario et en technologie, et a été nommé le meilleur employeur de PME au Canada pendant 3 ans !
En savoir plus !In this blog, I’ll demonstrate opening a PDB in a hybrid read-only mode, and then test a DML command from common and local users.
Prerequisites:
– Connect to the root container as SYS, close the PDB, then open the PDB in hybrid read-only mode.
SQL> alter pluggable database &PDB_NAME close immediate instances=all; SQL> alter pluggable database &PDB_NAME OPEN HYBRID READ ONLY instances=all;
Note: The pluggable database open mode will be READ WRITE even after opening in hybrid read-only mode.
– Connect to the PDB as HR and run a DML statement
– You will get the below error message
SQL Error: ORA-16000: Attempting to modify database or pluggable database that is open for read-only access.
– Connect to the PDB as system HR and run a DML statement
– A DML statement will be executed without error
Overview: In previous Database releases, you could store flashback database logs only in the fast recovery area Oracle 23c Database introduces the ... Read More
Overview: Oracle 23c Database introduces a new feature to control whether a user or session is enabled for read-write operations, irrespective of the ... Read More