Library /sys$common/syshlp/RDOHELP72.HLB  —  DELETE_DATABASE
    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
Format More Examples
Close Help