Example 1: Deleting files only

    The following statement deletes the database system files for
    the database associated with the database personnel.rdb. If this
    database also had definitions stored in a repository directory,
    this DROP DATABASE statement would not delete those definitions.

    SQL> DROP DATABASE FILENAME personnel;

    Example 2: Deleting files and repository definitions

    To delete database files and repository definitions, you
    must specify a repository path name in the DROP DATABASE
    statement. This statement deletes the repository directory
    CDD$TOP.ACCOUNTING.PERSONNEL in addition to all database root
    and storage area files associated with it.

    SQL> DROP DATABASE PATHNAME CDD$TOP.ACCOUNTING.PERSONNEL;