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:
Name of the Pluggable Database.
Query Parameters
-
action:
Specify if datafiles should be removed or not. The value can be INCLUDING or KEEP (default).
-
getScript:
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.
Response
200 Response
The response will indicate the successful execution of a series of PL/SQL statements, or return a set of PL/SQL statements that could be executed to create a pluggable database.