HELPLIB.HLB  —  ORACLE_RDB72, System Tables, RDB$STORAGE_MAP_AREAS
    The RDB$STORAGE_MAP_AREAS system table contains information about
    each storage area to which a storage map refers. The following
    table provides information on the columns of the RDB$STORAGE_MAP_
    AREAS system table.

                                Data
    Column Name                 Type      Summary Description

    RDB$MAP_NAME                char(31)  The name of the storage
                                          map.
    RDB$AREA_NAME               char(31)  The name of the storage
                                          area referred to by the
                                          storage map.
    RDB$ROOT_DBK                char(8)   A pointer to the root of
                                          the SORTED index, if it is
                                          a SORTED index.
    RDB$ORDINAL_POSITION        integer   The order of the storage
                                          area represented by this
                                          row in the map.
    RDB$STORAGE_ID              integer   For a table, a pointer
                                          to the database logical
                                          area. For a hashed index,
                                          a pointer to the system
                                          record.
    RDB$INDEX_ID                integer   A pointer to the index
                                          logical area.
    RDB$STORAGE_BLR             list      The BLR that represents
                                of byte   the SQL clause, WITH LIMIT
                                varying   OF, in the storage map
                                          definition.
    RDB$DESCRIPTION             list      Description of this
                                of byte   partition.
                                varying
    RDB$EXTENSION_PARAMETERS    list      Lists table names and
                                of byte   column names that are
                                varying   referenced by segmented
                                          string storage maps.
    RDB$VERTICAL_PARTITION_     integer   For LIST storage maps,
    INDEX                                 the value indicates the
                                          relationship between areas
                                          of a LIST storage map area
                                          set.
    RDB$FLAGS                   integer   Flags.
    RDB$SECURITY_CLASS          char(20)  Reserved for future use.
    RDB$PARTITION_NAME          char(31)  Name of the index or
                                          storage map partition.

1  –  RDB$FLAGS

    Represents flags for RDB$STORAGE_MAP_AREAS system table.

    Bit
    Position   Description

    0          If Bit 0 is clear, the LIST storage area set is filled
               randomly.

               If Bit 0 is set, the LIST storage area set is filled
               sequentially.
    1          User named this partition.
    2          BUILD PARTITION is required.
    3          Deferred build using NOLOGGING.
Close Help