Specifying the Starting Page Number of a Secondary File

Go Up to Using CREATE DATABASE

If you do not declare a length for a secondary file, then you must specify a starting page number. STARTING AT specifies the beginning page number for a secondary file. The PAGE keyword is optional. You can specify a combination of length and starting page numbers for secondary files.

If you specify a STARTING AT parameter that is inconsistent with a LENGTH parameter for the previous file, the LENGTH specification takes precedence:

CREATE DATABASE 'employee.ib' LENGTH 10000
FILE 'employee2.ib' LENGTH 10000 PAGES
FILE 'employee3.ib' LENGTH 10000 PAGES
FILE 'employee4.ib';

The following example produces exactly the same results as the previous one, but uses a mixture of LENGTH and STARTING AT:

CREATE DATABASE 'employee.ib'
FILE 'employee2.ib' STARTING AT 10001 LENGTH 10000 PAGES
FILE 'employee3.ib' LENGTH 10000 PAGES
FILE 'employee4.ib';