Library /sys$common/syshlp/SQL$HELP72.HLB  —  CREATE  STORAGE_AREA, Arguments  INTERVAL
    Syntax options:

    INTERVAL IS number-data-pages

    Specifies the number of data pages between SPAM pages in the
    storage area file, and thus the maximum number of data pages each
    SPAM page manages. The default, and also the minimum interval,
    is 216 data pages. The first page of each storage area is a SPAM
    page. The interval you specify determines where subsequent SPAM
    pages are to be inserted if there are enough data pages in the
    storage file to require more SPAM pages.

    You cannot specify the INTERVAL storage area parameter unless you
    also explicitly specify PAGE FORMAT IS MIXED.

    Oracle Rdb calculates the maximum INTERVAL size based on the
    number of blocks per page, and returns an error message if you
    exceed this value. For example, when the page size is 2 blocks,
    the maximum INTERVAL is 4008 pages. If you try to create a
    storage area with the INTERVAL set to 4009, Oracle Rdb returns
    the following error message:

    %RDB-E-BAD_DPB_CONTENT, invalid database parameters in the database parameter
    block (DPB)
    -RDMS-F-SPIMAX, spam interval of 4009 is more than the Rdb maximum of 4008
    -RDMS-F-AREA_NAME, area NEW

    For more information about setting space area management
    parameters, see the Oracle Rdb Guide to Database Maintenance.
Close Help