Oracle-L: SQL*Plus/UTL_FILE vs. 3'rd Party Data Extraction

From: Post, Ethan <Ethan.Post_at_ps.net>
Date: Tue, 02 Jul 2002 08:28:37 -0800
Message-ID: <F001.0048DFA7.20020702082837@fatcity.com>

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). Received on Tue Jul 02 2002 - 11:28:37 CDT