Drop a PDB
delete
/database/pdbs/{pdb_name}
Drop a pluggable database. This service requires db.cdb.adminUser credentials to be set in the pool configuration. A client requires SQL Administrator role to invoke this service.
Request
Path Parameters
-
pdb_name(required): string
Name of the Pluggable Database.
Query Parameters
-
dryrun: boolean
If defined, the response will contain a JSON object with the information of the script that was generated for execution. Script execution does not happen and the database is not dropped.
-
force: boolean
To drop an orphaned application root container
-
including_datafiles: boolean
To delete the data files associated with the PDB being dropped. The temp file for the PDB is also deleted
-
keep_datafiles: boolean
To retain the data files associated with the PDB after the PDB is dropped..
There's no request body for this operation.
Back to TopResponse
204 Response
The response will indicate the successful execution of a series of PL/SQL statements.