pluggable

How to rename a pluggable database ( PDB)

We can easily rename a pluggable database. Follow below steps. Start the PDB with restrict mode SQL> alter session set container=PROD_CL; Session altered. SQL> shutdown immediate; Pluggable Data...

How to clone a pluggable database for existing PDB

In this article we will clone a pluggable database from existing PDB ( PROD), residing on the same container. First start the PDB in read only , which need to be cloned. SQL> select name,open_mode ...

How to create a pluggable database in oracle 12c

We can create a pluggable database in an existing multitenant database either using dbca or manually. Here we will show how to do it manually.   STEPS: Connect to the container database:(ROOT) &n...

How to create a multi tenant database in oracle 12c

If you haven’t installed 12C ORACLE_HOME, then below the below link. Install oracle database 12c software Once installation is done, Let’s create one container database(CDB) with 2 pluggab...