Library /sys$common/syshlp/SQL$HELP_OLD72.HLB  —  CREATE  DATABASE  Arguments  DEFAULT_STORAGE_AREA
    Specifies a default storage area to which all user data and
    unmapped indexes are stored. The DEFAULT STORAGE AREA parameter
    separates user data from the system data, such as system tables.
    RDB$SYSTEM is the default area if you do not specify a default
    storage area.

    In addition to user data, Oracle Rdb stores the following system
    tables in the default storage area:

    o  RDB$INTERRELATIONS

    o  RDB$MODULES

    o  RDB$ROUTINES

    o  RDB$PARAMETERS

    o  RDB$QUERY_OUTLINES

    o  RDB$SEQUENCES

    o  RDB$PROFILES

    o  RDB$GRANTED_PROFILES

    o  RDB$TYPES

    o  RDB$TYPE_FIELDS

    o  RDB$WORKLOAD

    o  RDB$OBJECT_SYNONYMS

    o  RDB$SYNONYMS

    o  RDB$CATALOG_SCHEMA

    For information on moving these system tables to other
    storage areas, see the Oracle Rdb Guide to Database Design and
    Definition.

    The DEFAULT STORAGE AREA parameter must reference an existing
    storage area. You must create the storage area using the CREATE
    STORAGE AREA clause in the same CREATE DATABASE statement as the
    DEFAULT STORAGE AREA parameter.
Close Help