Oracle-L: Re: External tables

From: <Jared.Still_at_radisys.com>
Date: Thu, 24 Apr 2003 10:16:54 -0800
Message-ID: <F001.00588A09.20030424101654@fatcity.com>

The replies so far have failed to mention that parallel loading with external tables is easy. With sqlloader, it ain't so easy.

With external tables, it is also easy to do additional processing via SQL when you load. In many cases you could avoid extra steps required in sqlloader, such as loading to a temp table, then massaging your data and loading to a perm table.

You can skip the temp table with external tables.

Jared

David Turner <turner_at_tellme.com>
Sent by: root_at_fatcity.com
04/23/2003 03:31 PM
Please respond to ORACLE-L

        To:     Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
        cc: 
        Subject:        External tables

Has anyone benchmarked external tables versus sqlldr for loading data? Before
I start using external tables I thought I'd see if it was worth my time.

Dave
--

Please see the official ORACLE-L FAQ: http://www.orafaq.net
--

Author: David Turner
INET: turner_at_tellme.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------

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.net
--

Author:
INET: Jared.Still_at_radisys.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------