Enables or disables the modes specified leaving the previously
    defined or default modes enabled. This is an offline operation
    and requires exclusive database access.

    If the current transaction modes are SHARED and READ ONLY and you
    want to add the EXCLUSIVE mode, use the following statement:

    SQL> ALTER DATABASE FILENAME mf_personnel
    cont>   ALTER TRANSACTION MODES (EXCLUSIVE);