Here are the steps to create new pluggable database unsing the seed
SYS@ORCL19 SQL> show pdbs
CON_ID CON_NAME OPEN MODE RESTRICTED
---------- ------------------------------ ---------- ----------
2 PDB$SEED READ ONLY NO
3 PLUG19 READ WRITE NO
4 SINGLEPLUG READ WRITE NO
I will not specify the file_name_convert parameter, as I am using ASM and oracle will take care of that.
SYS@ORCL19 SQL> create pluggable database newplug admin user adminuser identified by KJfw94ut04ejdsjf roles=(dba);
Pluggable database created.
SYS@ORCL19 SQL> show pdbs
CON_ID CON_NAME OPEN MODE RESTRICTED
---------- ------------------------------ ---------- ----------
2 PDB$SEED READ ONLY NO
3 PLUG19 READ WRITE NO
4 SINGLEPLUG READ WRITE NO
5 NEWPLUG MOUNTED
SYS@ORCL19 SQL> alter pluggable database newplug open read write;
Pluggable database altered.
SYS@ORCL19 SQL> show pdbs
CON_ID CON_NAME OPEN MODE RESTRICTED
---------- ------------------------------ ---------- ----------
2 PDB$SEED READ ONLY NO
3 PLUG19 READ WRITE NO
4 SINGLEPLUG READ WRITE NO
5 NEWPLUG READ WRITE NO
SYS@ORCL19 SQL> alter session set container=newplug;
Session altered.
SYS@ORCL19 SQL> show con_name
CON_NAME
------------------------------
NEWPLUG
CON_ID CON_NAME OPEN MODE RESTRICTED
---------- ------------------------------ ---------- ----------
2 PDB$SEED READ ONLY NO
3 PLUG19 READ WRITE NO
4 SINGLEPLUG READ WRITE NO
I will not specify the file_name_convert parameter, as I am using ASM and oracle will take care of that.
SYS@ORCL19 SQL> create pluggable database newplug admin user adminuser identified by KJfw94ut04ejdsjf roles=(dba);
Pluggable database created.
SYS@ORCL19 SQL> show pdbs
CON_ID CON_NAME OPEN MODE RESTRICTED
---------- ------------------------------ ---------- ----------
2 PDB$SEED READ ONLY NO
3 PLUG19 READ WRITE NO
4 SINGLEPLUG READ WRITE NO
5 NEWPLUG MOUNTED
SYS@ORCL19 SQL> alter pluggable database newplug open read write;
Pluggable database altered.
SYS@ORCL19 SQL> show pdbs
CON_ID CON_NAME OPEN MODE RESTRICTED
---------- ------------------------------ ---------- ----------
2 PDB$SEED READ ONLY NO
3 PLUG19 READ WRITE NO
4 SINGLEPLUG READ WRITE NO
5 NEWPLUG READ WRITE NO
SYS@ORCL19 SQL> alter session set container=newplug;
Session altered.
SYS@ORCL19 SQL> show con_name
CON_NAME
------------------------------
NEWPLUG
Now, we will drop database:
SYS@ORCL19 SQL> alter session set container=cdb$root;
Session altered.
SYS@ORCL19 SQL> alter pluggable database newplug close immediate;
Pluggable database altered.
SYS@ORCL19 SQL> drop pluggable database newplug including datafiles;
Pluggable database dropped.
SYS@ORCL19 SQL> show pdbs
CON_ID CON_NAME OPEN MODE RESTRICTED
---------- ------------------------------ ---------- ----------
2 PDB$SEED READ ONLY NO
3 PLUG19 READ WRITE NO
4 SINGLEPLUG READ WRITE NO
SYS@ORCL19 SQL> alter session set container=cdb$root;
Session altered.
SYS@ORCL19 SQL> alter pluggable database newplug close immediate;
Pluggable database altered.
SYS@ORCL19 SQL> drop pluggable database newplug including datafiles;
Pluggable database dropped.
SYS@ORCL19 SQL> show pdbs
CON_ID CON_NAME OPEN MODE RESTRICTED
---------- ------------------------------ ---------- ----------
2 PDB$SEED READ ONLY NO
3 PLUG19 READ WRITE NO
4 SINGLEPLUG READ WRITE NO