To delete a view with the DEFINE VIEW statement, you must have
    the Oracle Rdb DELETE privilege to the view.

    You must execute this statement in a read/write transaction.
    If there is no active transaction and you issue this statement,
    Oracle Rdb starts a read/write transaction implicitly.

    Deleting a view does not affect other users until you commit your
    transaction, and users detach from the database and attach again.