Hi,
Does the DIRECT load option activate triggers during insert?
Simon
-----Original Message-----
From: Lars Eskildsen [mailto:[EMAIL PROTECTED]]
Sent: Thursday, April 26, 2001 9:56 AM
To: 'Randy Norwood'; 'DBI Users'
Subject: RE: Oracle sqlload alternatives?
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
