Perl is so good at dealing with text that there's no need for a
separate loader utility. You parse the text via standard Perl or
a package for specific formats (e.g., Text::CSV_XS is a good one
for CSV files). Once parsed, you use DBI to insert or update
database rows.
----
Steve Sapovits
Global Sports Interactive
Work Email: [EMAIL PROTECTED]
Home Email: [EMAIL PROTECTED]
Work Phone: 610-491-7087
Cell: 610-574-7706
Pager: 877-239-4003
> -----Original Message-----
> From: Randy Norwood [SMTP:[EMAIL PROTECTED]]
> Sent: Thursday, April 26, 2001 9:29 AM
> 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
>
