Oracle 23ai: Bigfile Tablespace Shrink
Overview: If you try to resize/shrink a datafile before Oracle Database 23ai, you’ll get “ORA-03297: file contains used data beyond ... 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 enable/disable READ ONLY for a PDB local database user.
Prerequisites:
1. Connect to a PDB using HR local database user and run a DML statement.
– Dictionary view *_USERS currently shows that READ_ONLY is disabled for HR user.
2. Connect to a PDB using a SYSTEM common user and enable READ ONLY for HR users using below SQL Command.
SQL> alter user &USERNAME read only;
3. Reconnect to a PDB using the HR local database user and run a DML statement.
– Dictionary View *_USERS currently shows that READ_ONLY is enabled for HR user.
– You will get the below error message.
SQL Error: ORA-28194: Can perform read operations only
4. Using the SYSTEM Database Session, disable READ ONLY for HR users using the below SQL Command.
SQL> alter user &USERNAME read write;
5. Reconnect to a PDB using the HR Local Database User and run a DML statement. DML statement will run without error.
– Dictionary view *_USERS currently shows that READ_ONLY is disabled for HR user.
Overview: If you try to resize/shrink a datafile before Oracle Database 23ai, you’ll get “ORA-03297: file contains used data beyond ... Read More
Overview: In previous Database releases, you could store flashback database logs only in the fast recovery area Oracle 23c Database introduces the ... Read More