Hello,
I would like to create a multifile firebird database.I found how to do that by,
CREATE DATABASE  “c:\test\test.fdb”
USER 'sysdba' PASSWORD 'masterkey'
PAGE_SIZE 8192
LENGTH 10000 PAGES
FILE  “c:\test\test.fd1” LENGTH 10000
FILE “c:\test\test.fd2”;
 

I wanted that Table_1 reside in Primary file and Table_2 reside in First secondary File(test.fd1) and table_3 reside in secnd secondary file(test.fd2)..
For this i tried,
CREATE TABLE TABLE_2 EXTERNAL FILE 'C:\test\test.fd1'
(TABLE_2_ID smallint not null);
 
But when i tried to insert values to table2 i got error
Statement failed, SQLCODE = -902
Access to external file "C:\TEST\TEST.FD1" is denied by server administrator
 
Because EXTERNAL FILE 'filename' will be opened read-only
Can we specify which table should go in which file in a multifile firebird database with all features?
 
Please help me with this.
 
Thanks
DK
 




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