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