Re: faster than SQLLOADER
From: Bill Manry - Oracle Corporation <bmanry_at_upsizeme.us.oracle.com>
Date: 4 Jan 1995 18:08:05 GMT
Message-ID: <3eeo65$q3b_at_dcsun4.us.oracle.com>
Bill Manry
Oracle Corp. / Mainframe & Integration Technologies / BManry_at_us.oracle.com #include <disclaimer.usual> Received on Wed Jan 04 1995 - 19:08:05 CET
Date: 4 Jan 1995 18:08:05 GMT
Message-ID: <3eeo65$q3b_at_dcsun4.us.oracle.com>
SQL*Loader with direct=true uses an RDBMS interface designed specifically for loading. All other techniques that I know of (including import) use SQL "INSERT" and are likely to be slower.
/b
Bill Manry
Oracle Corp. / Mainframe & Integration Technologies / BManry_at_us.oracle.com #include <disclaimer.usual> Received on Wed Jan 04 1995 - 19:08:05 CET