Deletes one or more databases. When this statement executes,
Oracle Rdb deletes the database files associated with the
database. If you use the PATHNAME argument, Oracle Rdb deletes the
CDD$DATABASE entity in the data dictionary that contains the
database definitions.
You cannot delete a database when there are users attached to the
database, including yourself. That is, issue the DELETE DATABASE
statement before you invoke the database.
USE THE DELETE DATABASE STATEMENT WITH CARE. When you use this
statement, Oracle Rdb deletes the physical database file, which
includes all data and all definitions.
Example:
DELETE DATABASE PATHNAME 'PERSONNEL'.
Additional Information:
explode
extract