Syntax option:
ALLOCATION IS number-pages PAGES
The number of database pages initially allocated to the storage
area. Rdb will automatically extend this allocation to account
for internal structure pages, such as SPAM (spage management)
pages. For example, an allocation of 25 will be increased to 27
as shown in this example:
SQL> alter database filename MF_PERSONNEL
cont> add storage area DOC_EXAMPLE
cont> page format is uniform
cont> allocation 25;
SQL> attach 'filename MF_PERSONNEL';
SQL> show storage area DOC_EXAMPLE
DOC_EXAMPLE
Access is: Read write
Page Format: Uniform
Page Size: 2 blocks
Area File: USER_DISK:[DOC.DATABASES]DOC_EXAMPLE.RDA;1
Area Allocation: 27 pages
Extent: Enabled
Area Extent Minimum: 99 pages
Area Extent Maximum: 9999 pages
Area Extent Percent: 20 percent
Snapshot File: USER_DISK:[DOC.DATABASES]DOC_EXAMPLE.SNP;1
Snapshot Allocation: 100 pages
Snapshot Extent Minimum: 99 pages
Snapshot Extent Maximum: 9999 pages
Snapshot Extent Percent: 20 percent
Locking is Row Level
No Cache Associated with Storage Area
No database objects use Storage Area DOC_EXAMPLE