Dropping Database

About Dropping the Database

This option is used to drop an existing database. It deletes all the physical database files and uncatalogs the database. When you drop a database, the <instance home>/<database name> directory is not deleted. You can manually remove this directory, if required.

This task explains the procedure to drop a database:

  1. Login as aspadm user and run edm.sh from $EDS_HOME/bin directory. For additional information, see Using CES Database Manager.

  2. From the EDM main window, select a database that is to be dropped.

  3. Select Administration > Drop Database option.

    The Drop Database window appears
    .

  4. The Instance Name and Database Name (that is to be dropped) appears. Click Drop to drop the database. The warning message appears:
    Click Yes to drop the database. This will lead to complete loss of data and the database and its data may not be recoverable.

    If you select Yes, the database will be dropped and a message indicating that the operation is successful appears.

  5. Click Cancel to return to the EDM main menu.