Library /sys$common/syshlp/SQL$HELP72.HLB  —  ALTER  DATABASE  Arguments  ALTER_STORAGE_AREA
    Specifies the name of an existing storage area in the database
    that you want to alter. You can use the ALTER STORAGE AREA clause
    only on multifile databases.

    You can specify RDB$SYSTEM for the area-name if you are altering
    the following clauses:

    o  ALLOCATION IS number-pages PAGES

    o  extent-params

    o  CACHE USING row-cache-name

    o  NO ROW CACHE

    o  SNAPSHOT ALLOCATION IS snp-pages PAGES

    o  SHAPSHOT EXTENT

    o  CHECKSUM CALCULTION

    o  SNAPSHOT CHECKSUM CALCULATION

    Oracle Rdb generates an error if you specify RDB$SYSTEM or the
    DEFAULT storage area as the area-name when altering the following
    clauses:

    o  LOCKING IS PAGE LEVEL

    o  READ WRITE

    o  READ ONLY

    If you want to change the read-only and read/write parameters of
    the RDB$SYSTEM storage area using the ALTER DATABASE statement,
    you must specify these parameters outside of the ALTER STORAGE
    AREA clause.
Close Help