Library /sys$common/syshlp/SQL$HELP_OLD72.HLB  —  CREATE  DATABASE  Arguments  INTERVAL
    Specifies the number of data pages between space area management
    (SPAM) pages in the storage area file, and therefore the maximum
    number of data pages each space area management page will manage.
    The default, and also the minimum interval, is 216 data pages.
    The first page of each storage area is a space area management
    page. The interval you specify determines where subsequent space
    area management pages are to be inserted, provided there are
    enough data pages in the storage file to require more space area
    management pages.

    You cannot specify the INTERVAL storage area parameter for
    single-file databases, and you cannot specify INTERVAL 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