At 02:15 AM 05-12-01 +0000, you wrote:

>hi i like to know how to i create multi-file databases for interbase6.

Starting from no existing database:

CREATE DATABASE 'mydb.gdb'
PAGE_SIZE 8192
DEFAULT CHARACTER SET ....
....
FILE 'mydb.gd1' STARTING AT PAGE 10001
LENGTH 10000 PAGES ;
creates a two-file database.

Starting with an existing database, you have more than one way to do it:

ALTER DATABASE
ADD FILE 'mydb.gd2' STARTING AT PAGE 20001
LENGTH 10000 PAGES
ADD FILE 'mydb.gd3' STARTING AT PAGE 30001
LENGTH 10000 PAGES ;

Or you can make a gbak backup and restore it as a multi-file database:
gbak -c mydb.gbk mydb.gdb
10000 mydb.gd1
10000 mydb.gd2
10000 mydb.gd3

Other options include backing up to multiple backup files and restoring from multiple backup files to multiple database files...

regards,
Helen

All for Open and Open for All
InterBase Developer Initiative · http://www.interbase2000.org
_______________________________________________________