Subject Re: [firebird-support] Secondary Files
Author Martijn Tonies
> I need to specify a size limit to my primary gdb file with a size
lower them 3 Gb (what is automatic, as i know). I intend to limit this file
to 1Gb then, after start to fill a secondary file. To do this i used the
folowing command to test:
> SQL> create database '/database/test.gdb'
> CON> PAGE_SIZE = 4096
> CON> length = 2000
> CON> FILE '/database/test2.gdb' starting at 2001;
> I think that could limit test.gdb to 2000 pages only, but the
secondary file was not filled automaticaly.
> Can anybody say me why ?

The secondary file will stay empty until the primary file is "full".

With regards,

Martijn Tonies
Database Workbench - tool for InterBase, Firebird, MySQL, Oracle & MS SQL
Upscene Productions
Database development questions? Check the forum!