| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> Re: SQL*Plus/UTL_FILE vs. 3'rd Party Data Extraction
Perl is very fast, very flexible, and quite inexpensive. :)
See my post earlier today that includes the TOC from "Perl for Oracle DBA's"
Jared
"Post, Ethan" <Ethan.Post_at_ps.net>
Sent by: root_at_fatcity.com
07/02/2002 09:28 AM
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
cc:
Subject: SQL*Plus/UTL_FILE vs. 3'rd Party Data Extraction
I have some people who are asking about 3'rd party data extraction tools
to
pull data from Oracle into text files for loading a data warehouse. I am
not sure what the size of the project is but I think it is pretty big. The
DW is Terradata. Anyway, they are stating Oracle tools are too slow. They
do not define slow so it is hard to argue with them. My opinion is that
it
is very dependent on hardware (CPU/Disk) in most cases.
What are your opinions on the matter, do you need 3'rd party? What tools are you using (I am aware of Informatica and such but I think they are looking for something a little cheaper)?
Thanks,
Ethan Post
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Post, Ethan
INET: Ethan.Post_at_ps.net
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists --------------------------------------------------------------------To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
INET: Jared.Still_at_radisys.com
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists --------------------------------------------------------------------To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Tue Jul 02 2002 - 13:26:31 CDT
 |
 |