Re: Bulkcopy

The 9i feature is apparently called "external tables" and there is a publicly available mention of it here:

http://technet.oracle.com/products/oracle9i/htdocs/9ipak/bi/etl/etl.html#ExternalTables

Bill

dgoulet_at_vicr.com wrote:

> Glenn,
>
> At the last NorthEast Oracle Users Group meeting we had a developer from
> Oracle in Nashua NH who's purpose in life is the utilities like SQL*Loader,
> Export and Import. He told us of the "replacement of SQL*Loader" in Oracle 9.
> Basically you've hit it on the head. You place the file somewhere where the DB
> can see it and using SQL*Loader like syntax describe the table(s) to the
> database. Then you can use plain old SQL to either read and process the data or
> manipulate it as you like. I believe he said we could even index the data
> therein and that it could be used for either data extraction and insertion.
> Sounds interesting, can't wait to get my hands on it.

--

______________________________________________
http://www.datacraft.com/    http://plnet.org/


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Bill Pribyl
  INET: bill_at_datacraft.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).