How to drop pluggable database in Oracle 19c?

Dropping Pluggable Database :

We can drop the pluggable database using DROP PLUGGABLE DATABASE statement from the root container.

Step 1: Check which pdb you want to drop (In my case PDBTEST)

[code] [dev:oracle:ORCL}$ sqlplus / as sysdba SQL*Plus: Release 19.0.0.0.0 - Production on Sun May 17 17:13:24 2020 Version 19.3.0.0.0 Copyright (c) 1982, 2019, Oracle. All rights reserved. Connected to: Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production Version 19.3.0.0.0 SQL> show con_name CON_NAME ------------------------------ CDB$ROOT SQL> show pdbs CON_ID CON_NAME OPEN MODE RESTRICTED ---------- ------------------------------ ---------- ---------- 2 PDB$SEED READ ONLY NO 3 ORCLPDB READ WRITE NO 4 PDBTEST READ WRITE NO SQL> [/code]

Step 2: Close pluggable database

[code] SQL> alter pluggable database PDBTEST close; Pluggable database altered. SQL> show pdbs CON_ID CON_NAME OPEN MODE RESTRICTED ---------- ------------------------------ ---------- ---------- 2 PDB$SEED READ ONLY NO 3 ORCLPDB READ WRITE NO 4 PDBTEST MOUNTED SQL> [/code]

Step 3: Drop PDBTEST

[code] SQL> drop pluggable database PDBTEST; drop pluggable database PDBTEST * ERROR at line 1: ORA-65179: cannot keep datafiles for a pluggable database that is not unplugged [/code]

Here I got error, We can not keep datafiles when we are dropping that PDB unless we unplugged it.
Hence, lets drop it using including datafiles option

[code] SQL> drop pluggable database PDBTEST including datafiles; Pluggable database dropped. SQL> show pdbs CON_ID CON_NAME OPEN MODE RESTRICTED ---------- ------------------------------ ---------- ---------- 2 PDB$SEED READ ONLY NO 3 ORCLPDB READ WRITE NO SQL> [/code]

We can see here the pluggable database is dropped.