In this post, we can use deletePluggableDatabase command creates a pluggable database (PDB) in a multitenant container database (CDB) with DBCA in Oracle 18c.
[oracle@18c admin]$ dbca -silent -deletePluggableDatabase -pdbName DBCAPDB -sourceDB CDB18C Prepare for db operation 25% complete Deleting Pluggable Database 40% complete 85% complete 92% complete 100% complete Pluggable database "DBCAPDB" deleted successfully. Look at the log file "/u01/app/oracle/cfgtoollogs/dbca/CDB18C/DBCAPDB/CDB18C0.log" for further details.
Let’s connect to the database and check the PDB is deleted or not.
[oracle@18c admin]$ sqlplus / as sysdba SQL*Plus: Release 18.0.0.0.0 Production on Mon Apr 23 15:07:58 2018 Version 18.1.0.0.0 Copyright (c) 1982, 2017, Oracle. All rights reserved. Connected to: Oracle Database 18c Enterprise Edition Release 18.0.0.0.0 - Production Version 18.1.0.0.0 SQL> show pdbs CON_ID CON_NAME OPEN MODE RESTRICTED ---------- --------- ---------- ----------- 2 PDB$SEED READ ONLY NO 3 PDB18C1 MOUNTED 4 PDB18C2 READ WRITE NO 7 PDB18CSNAP READ WRITE NO SQL>
Stay tuned for more articles on Oracle 18c
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: https://t.me/helporacle
Skant Gupta’s LinkedIn: www.linkedin.com/in/skantali/
Joel Perez’s LinkedIn: Joel Perez’s Profile
LinkedIn Group: Oracle Cloud DBAAS
Facebook Page: OracleHelp
