In this Article, we will see how we can open a Pluggable Database in different modes and changing the setting of particular pdb.

Pluggable Database Modes :

  1. Open Pluggable Database in Restricted Mode

First what is restricted mode : All user having create session privilege can connect to normally opened database. But when your database is opened in restricted mode you need special privilege called  restricted session .

You need both Create a session and restricted session privilege to connect with the database if it is opened in restricted mode.

Generally only DBA have this permission.

Now to open a database in restricted mode use following steps.

After opening pdb in a restricted mode you can see in shows PDBs you can see YES in the Restricted state.

Open Pluggable Database in Read-Only Mode

Check open_mode of a pluggable database in v$pdbs

To open a pluggable database in fully updatable mode use following command

Above statement will open a pluggable database in read-write mode

*Modifying PDB Settings

We can do the following task with PDBs.

  1. You can make datafile offline or online.

2. Changing the default tablespace

3. Setting the storage limit for a pluggable database

Above are an example we can set in a pluggable database.

Stay tuned for More articles on Oracle Multitenant

Thank you for giving your valuable time to read the above information.

If you want to be updated with all our articles send us the Invitation or Follow us:

Telegram Channel:

Skant Gupta’s LinkedIn:

Joel Perez’s LinkedIn: Joel Perez’s Profile

LinkedIn Group: Oracle Cloud DBAAS

Facebook Page: OracleHelp


About The Author

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.