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.