Using LENGTH to Specify a Secondary File

Go Up to Using CREATE DATABASE

The LENGTH parameter specifies the number of database pages for the file. The eventual maximum file size is then the number of pages times the page size for the database. (See Specifying Database Page Size.) The following example creates a database with a primary file and three secondary files. The primary file and the first two secondary files are each 10,000 pages long.

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

Note

Because file-naming conventions are platform-specific, for the sake of simplicity, none of the examples provided include the device and path name portions of the file specification.