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
Learn more about why Eclipsys has been certified as a Great Place to Work in Canada, Best Workplaces in Ontario and Technology, and named Canada’s Top SME Employer for 3 years!
Learn more!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