Hi Mark,

you can declare an Table as an external file and use
this to import your data:

create table ext_tbl external file 'file.txt' (
fname char(10),
new_line char(1));

On my unix system, the file.txt is locatet in /tmp.
The file.txt is an plain text file with fixed length.

The file.txt is the file with your millions of
records. After that you can insert them into another
table by insert into select from statement.

That sould be the fastest way.

CU Chris


__________________________________________________________________

Gesendet von Yahoo! Mail - http://mail.yahoo.de
Logos und Klingeltöne fürs Handy bei http://sms.yahoo.de