Subject | Re: Problem in Bulk Insertion in Firebird |
---|---|
Author | Manish Lal Joshi |
Post date | 2007-02-22T11:10:40Z |
I'm stuck in another problem now..
I did it like this:
1. Create EXTERNAL TABLE (TEMP1) with the file (dump.txt) i have dumped.
2. Then i inserted values in my original table (tb1) like
INSERT INTO tb1 SELECT TRIM(TRAILING '\0' FROM col1),col2 .. from TEMP1;
But while executing this query i got following problem after few
minutes....
I/O error for file fseek "D:\TEMP\dump.txt" Error while trying to open
file.
Info: My dump.txt file is almost 3 GB.
Is it memory issue i mean.. due to low memory.
Or is it something else..
Please help me
I did it like this:
1. Create EXTERNAL TABLE (TEMP1) with the file (dump.txt) i have dumped.
2. Then i inserted values in my original table (tb1) like
INSERT INTO tb1 SELECT TRIM(TRAILING '\0' FROM col1),col2 .. from TEMP1;
But while executing this query i got following problem after few
minutes....
I/O error for file fseek "D:\TEMP\dump.txt" Error while trying to open
file.
Info: My dump.txt file is almost 3 GB.
Is it memory issue i mean.. due to low memory.
Or is it something else..
Please help me