On Tue, 18 Nov 2003 18:22:17 +0000 (UTC), Graham King wrote:

> ...
> On another note. I noticed a while ago that Firebird failed on the
> following query:
> insert into tablea select * from tableb
> where tableb is an external fixed width file of >10GB (40.5 million
> records) and tablea is a native Firebird table. When the external file
> was split into smaller (512MB) chunks, the copy between tables worked
> fine (just took 20 external files to get all the data into tablea). Is
> this a known problem also?

Anything interesting in the log file?
Maybe you ran out of temp space for some index during the import?


--
Aage J.