Hi'
SQLLOAD is an Oracle utility program!
It has some nice features (at least from Oracle 7.3.4) like DIRECT load where records
are loaded directly into the datafiles instead of using insertion of records in tables
(which
requires transaction commit).
This is actually a very fast method (i am currently using DIRECT load option with
SQLLOAD and
it loads as much as 7.000.000 records of varying sizes into variuos tables in a couple
of
minutes (or there about)!
/Lars
-----Original Message-----
From: Randy Norwood [mailto:[EMAIL PROTECTED]]
Sent: 26. april 2001 15:29
To: [EMAIL PROTECTED]
Subject: Oracle sqlload alternatives?
We're trying to move some databases from MySQL to Oracle (using a DBI interface), and
would like to do batch loading from ascii text files, similar to MySQL's LOAD DATA
INFILE.
>From what I've been able to find on this list's archives, DBD:Oracle doesn't support
>this capability, or maybe it's that Oracle sqlload is an external utility.
Can someone shed some light on this, and suggest options for speedy loading of data
via DBI into Oracle?
thanks
--
+++++++++++++++++++++++
Randy Norwood, Technical Specialist
TNRCC Enforcement Division
Lead Internet Developer, OCE
http://www.tnrcc.state.tx.us
[EMAIL PROTECTED]
[EMAIL PROTECTED]
512-239-1879, 512-239-4562 fax
