after connectĬREATE PLUGGABLE DATABASE pdb_name ADMIN USER pdb_database_admin_user IDENTIFIED BY pdb_database_admin_user_passwordįILE_NAME_CONVERT = (pdbseed_location, new_pdb_location) Įxample: CREATE PLUGGABLE DATABASE pdbdev ADMIN USER pdbdevadmin IDENTIFIED BY DevAdmin#123įILE_NAME_CONVERT = ('/u01/app/oracle/oradata/ORCL/pdbseed/', '/u01/app/oracle/oradata/ORCL/pdbdev/') įirst of all we need to create new_pdb_location using following command: mkdir /u01/app/oracle/oradata/ORCL/pdbdev/ To create pdb database, first In SQL*Plus, ensure that the current container is the CDB root or an application root.
Here we have two PDB and one root PDB which is called SEED PDB. To create a PDB or an application container, the current container must be the root and you must have the CREATE PLUGGABLE DATABASE system privilege, granted commonly.įirst of all, connect database with SQLPlus with sys user: sqlplus /nologĪt now, to check connection name to make sure you’re in the correct location, type SQL> show con_name.The CDB must be open and in READ WRITE mode. This article describes how to Create New Pluggable Databases in Oracle 19c. To know details of CDB and PDB, you can go my article: Overview of CDB and PDB in Oracle Database - step by step to understand CDB and PDB
Pluggable Database in Oracle is a great feature of Multitenant architecture which is called PDB and PDB is created under CDB.
