Library /sys$common/syshlp/RDOHELP72.HLB  —  CHANGE_DATABASE, More
    You need the Oracle Rdb ADMINISTRATOR privilege to use the CHANGE
    DATABASE statement.

    Use CHANGE DATABASE to:

    o  Define, change, and delete storage areas in multifile
       databases

    o  Enable or disable after-image journaling and change journal
       file characteristics

    o  Enable or disable snapshot transactions and change snapshot
       file characteristics

    o  Change a read/write storage area to read-only, or a read-only
       storage area to read/write

    o  Change a storage area that contains only a segmented string to
       a format that can be stored on a write-once, read-many (WORM)
       device, using the WRITE_ONCE option.

    o  Change the number of recovery buffers

    o  Change physical parameters associated with the database

    o  Specify whether the database can be opened automatically or
       manually

    o  Require the use of the data dictionary

    o  Enable or disable global buffers

    o  Enable or disable fast commit processing

    o  Enable or disable carry-over lock optimization

    o  Set a database-wide timeout interval

    You cannot delete a storage area that is referred to in a storage
    map.
Close Help