1. Scripting Reference for Oracle Essbase
  2. MaxL
  3. MaxL Statements
  4. MaxL Statement Reference
  5. Drop Database

Drop Database

The MaxL drop database statement helps you delete an Essbase database. If the database has outstanding locks, you can clear them first, or use the force keyword to drop with locks. The minimum permission required to remove a database is Database Manager.

Syntax


Description of drpdb.gif follows
Description of the illustration drpdb.gif

DBS-NAME

Keywords

drop database DBS-NAME

Delete a database (cube) by name.

drop database DBS-NAME force

Delete a database that may have locked objects.

Example

drop database Sample.Basic force;

Deletes the database Sample.Basic, even if client users have outstanding locks on Sample.Basic.