Subject Re: External Tables
Author Bert_Herngreen
--- In, Helen Borrie <helebor@...>
> At 08:13 AM 1/11/2006, you wrote:
> >Hello,
> >
> >Is there a maximum file size that can be used with Firebird (2.0)
> >an external table?
> >If I use multiple files of 100 MB, there are no problems, but when
> >use a single file of 2.5 GB and 'insert into [Internal table]
> >from [External Table]' an IO error happens.
> >
> >I use Firebird 2.0 RC5 (on NTFS) with the fixed length file on
> It's a FAT32 limitation - 2Gb maximum addressable. Put the file on
> NTFS partition that was created by NT 5. Note that a NTFS
> that was created by NT 4.0 has a 4 Gb addressable limit.
> ./heLen

I thought that Fat32 knows a filesize limit of 4 GB, but probably I'm

A test with the 2.5 GB file (recreated) on the NTFS partition shows
the same error:

Statement failed, SQLCODE = -902
I/O error for file "C:\MONTHLY_BILLED_CALLS.TXT"
-Error while trying to open file
-Het apparaat herkent de opdracht niet.

When I produce 2 files of 1.25 GB there are no errors again.