User Guide : A. Command Reference : destroydb Command--Destroy a Database
 
Share this page                  
destroydb Command--Destroy a Database
Permission required: DBA or system administrator.
The destroydb command removes an existing database. The directory of the database and all files in that directory are removed. You cannot destroy the iidbdb using destroydb.
The destroydb command has the following format:
destroydb dbname [-p] [-l] [-uusername] [-Ppassword]
dbname
Specifies the name of the database.
-p
Prompts you to be sure that you want to destroy the database.
-l
Confirms if the database is in use, and if in use, returns with an error message.
-uusername
Specifies the effective user for the session, as described in Standard Flags and Parameters
-Ppassword
Specifies the user password for the database.
destroydb Examples
1. Destroy the sales_fact database:
destroydb sales_fact
2. Destroy the video database as the user Brad:
destroydb video -uBrad