We use the alter table command sometimes in production when I can't wait
for our nightly backup window... As far as how many pages to use that
depends on your page size that you chose for the database. I think the
default is 4k, but we usually use 8k on our larger databases. Just take
2 GB (2^31) and divide it by your page size (4k = 2^12) to get the
maximum number of pages (524288). I usually subtract off a bit because
I am afraid of getting too close to the limit. So for 4k page sizes we
use 511999 pages and for 8k we use 255998.

-steve

On Thu, 2005-06-16 at 15:00 +1000, Scott Buckham wrote:

> I found that you could use the 'ALTER TABLE ADD FILE filename' command
> some documentation suggested that you should put the number of pages
> sizes for all but the last file. Is this required, and if so, what
> would
> I specify to get limit the files to 2GB?
>
> Thanks,
>
> Scott
>
> -----Original Message-----
> From: firebird-support@yahoogroups.com
> [mailto:firebird-support@yahoogroups.com] On Behalf Of Ann W. Harrison
> Sent: Thursday, 16 June 2005 5:35 AM
> To: firebird-support@yahoogroups.com
> Subject: Re: [firebird-support] Spanning multiple files
>
> Scott Buckham wrote:
> > How do you set firebird (1.5.2) to span multiple files?
> >
>
> Connect to a multi-file database. How do you create a multi-file
> database? Specify multiple files and ranges either on the create
> database statement or on the command line of a gbak database restore.
>
> Regards,
>
>
> Ann
>
>
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
> Visit http://firebird.sourceforge.net and click the Resources item
> on the main (top) menu. Try Knowledgebase and FAQ links !
>
> Also search the knowledgebases at http://www.ibphoenix.com
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
> Yahoo! Groups Links
>
>
>
>
>
>
>
>
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
> Visit http://firebird.sourceforge.net and click the Resources item
> on the main (top) menu. Try Knowledgebase and FAQ links !
>
> Also search the knowledgebases at http://www.ibphoenix.com
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
> Yahoo! Groups Links
>
>
>
>
>
>
>


[Non-text portions of this message have been removed]