Re: How to get data into Oracle over a mediocre network connection

On Sat, 02 Jun 2007 16:13:54 -0700, "Martin T." <bilbothebagginsbab5_at_freenet.de> wrote:

>Well, there were no earlier attempts with _SQLLoader_. There were the
>attempts with x update stmts in a sql scripts and the exp/imp approach
>which failed utterly. The SQLLoader approach just worked ...
>
>If anyone likes to comment on why loading a table over the network via
>SQLLoader is 1000x faster than via imp (or SQL) I'd be more than
>happy ...

So far, you have been less than clear about the exact route you followed: no exact statements etc.
So how could anyone provide any comment? There are numerous factors at play. Imp will be slower if you don't specify the buffer= parameter, the commit=y parameter, etc, etc, etc.

-- 
Sybrand Bakker
Senior Oracle DBA