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
[EMAIL PROTECTED] 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: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).
