If you are in 9i then you can use external table. It's very fast(in secs) but you cannot create index and write to this table. If you want to write to this table then you can create table with select from the external table. If it's a continuous process then I think external table will work out best.