Library /sys$common/syshlp/SQL$HELP72.HLB  —  ALTER  DATABASE  Arguments  txn-modes
    Specifies the transaction modes for the database.

    Mode           Description

                            Transaction Types

    [NO]READ       Allows read-only transactions on the database.
    ONLY
    [NO]READ       Allows read/write transactions on the database.
    WRITE
    [NO] BATCH     Allows batch-update transactions on the database.
    UPDATE         This mode executes without the overhead, or
                   security, or a recovery-unit journal file.
                   The batch-update transaction is intended for
                   the initial loading of a database. Oracle Rdb
                   recommends that this mode be disabled.

                             Reserving Modes

    [NO] SHARED    Allows tables to be reserved for shared mode. That
    [READ |        is, other users can work with those tables.
    WRITE]
    [NO]           Allows tables to be reserved for protected mode.
    PROTECTED      That is, other users can read from those tables.
    [READ |
    WRITE]
    [NO]           Allows tables to be reserved for exclusive access.
    EXCLUSIVE      That is, other users are prevented access to those
    [READ |        tables, even in READ ONLY transactions.
    WRITE]
    ALL            Allows other users to work with all tables.
    NONE           Allows no access to tables.

    For detailed information about the txn-modes, see the SET_
    TRANSACTION.
Close Help