Enables only the modes specified, disabling all other previously
defined modes. For example, if a database is to be used for read-
only access and you want to disable all other transaction modes,
use the following statement:
SQL> CREATE DATABASE FILENAME mf_personnel
cont> SET TRANSACTION MODES (READ ONLY);
If not specified, the default transaction mode is ALL.
Specifying a negated transaction mode or specifying NONE disables
all transaction usage. Disabling all transaction usage would be
useful when, for example, you want to perform major restructuring
of the physical database. Execute the ALTER DATABASE statement
to re-enable transaction modes or use Oracle RMU, the Oracle Rdb
management utility.