From wweaver@rightnow.com Tue, 22 May 2001 08:42:05 -0700 From: "Weaver, Walt" Date: Tue, 22 May 2001 08:42:05 -0700 Subject: RE: RE: Bulkcopy Message-ID: MIME-Version: 1.0 Content-Type: text/plain Cool. Did he mention whether this is one of the features that would be "retrofitted" to V.8? That would be nice. I've been using Sqlloader quite a bit lately. --Walt Weaver Bozeman, Montana, USA -----Original Message----- Sent: Tuesday, May 22, 2001 9:57 AM To: Multiple recipients of list ORACLE-L 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. Dick Goulet ____________________Reply Separator____________________ Author: Glenn Travis Date: 5/22/2001 7:16 AM apologies. no offense was intended. on a side note, Informix has a feature that lets you define a table which references a flat file in unix. This allows them to bypass the buffer cache and facilitate fast table loads. I believe I read that this will be in Oracle 9 also, but I can't find the references at this time. Anyone have more info? -----Original Message----- From: root@fatcity.com [mailto:root@fatcity.com]On Behalf Of Carle, William T (Bill), NLCIO Sent: Monday, May 21, 2001 12:45 PM To: Multiple recipients of list ORACLE-L Subject: RE: Bulkcopy AT&T uses Oracle. I'm well acquainted with sqlldr, and I assumed that the questioner was too. I took his question to be: was there a bulkcopy utility in addition to sqlldr and the answer as far as I know is no. Bill Carle AT&T Database Administrator 816-995-3922 wcarle@att.com -----Original Message----- From: Glenn Travis [mailto:c-glenn.travis@wcom.com] Sent: Monday, May 21, 2001 2:20 PM To: Multiple recipients of list ORACLE-L Subject: RE: Bulkcopy sqlldr. AT&T obviously uses Sybase. -----Original Message----- From: root@fatcity.com [mailto:root@fatcity.com]On Behalf Of Carle, William T (Bill), NLCIO Sent: Monday, May 21, 2001 11:46 AM To: Multiple recipients of list ORACLE-L Subject: RE: Bulkcopy Howdy, The only bulkcopy utility that I know of is a Sybase utility. The Sybase bcp command moves data from a flat file to a Sybase table and vice versa. I don't know of any such command in Oracle. Bill Carle AT&T Database Administrator 816-995-3922 wcarle@att.com -----Original Message----- From: Robertson Lee - lerobe [mailto:lerobe@acxiom.co.uk] Sent: Monday, May 21, 2001 12:16 PM To: Multiple recipients of list ORACLE-L Subject: Bulkcopy All, Anyone heard of this utility for Oracle ?. Someone mentioned it today and I didn't have a clue. They said it would be in $ORACLE_HOME/bin. Nothing there !! Regards Lee The information contained in this communication is confidential, is intended only for the use of the recipient named above, and may be legally privileged. If the reader of this message is not the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, please re-send this communication to the sender and delete the original message or any copy of it from your computer system.

apologies. no offense was intended.

on a side note, Informix has a feature that lets you define a table which references a flat file in unix. This allows them to bypass the buffer cache and facilitate fast table loads. I believe I read that this will be in Oracle 9 also, but I can't find the references at this time. Anyone have more info?

-----Original Message-----
From: root@fatcity.com [mailto:root@fatcity.com]On Behalf Of Carle, William T (Bill), NLCIO
Sent: Monday, May 21, 2001 12:45 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: Bulkcopy

AT&T uses Oracle. I’m well acquainted with sqlldr, and I assumed that the questioner was too. I took his question to be: was there a bulkcopy utility in addition to sqlldr and the answer as far as I know is no.

< FONT color=#339966 face=Impact>

Bill Carle

AT&T

Database Administrator

816-995-3922

wcarle@att.com

-----Original Message-----
From: Glenn Travis [mailto:c-glenn.travis@wcom.com]
Sent: Monday, May 21, 2001 2:20 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: Bulkcopy

sqlldr. AT&T obviously uses Sybase.

-----Original Message-----
From: root@fatcity.com [mailto:root@fatcity.com]On Behalf Of Carle, William T (Bill), NLCIO
Sent: Monday, May 21, 2001 11:46 AM
To: Multiple recipients of list ORACLE-L
Subject: RE: Bulkcopy

Howdy,

The only bulkcopy utility that I know of is a Sybase utility. The Sybase bcp command moves data from a flat file to a Sybase table and vice versa. I don’t know of any such command in Oracle.

< FONT color=#339966 face=Impact>

Bill Carle

AT&T

Database Administrator

816-995-3922

wcarle@att.com

-----Original Message-----
From: Robertson Lee - lerobe [mailto:lerobe@acxiom.co.uk]
Sent: Monday, May 21, 2001 12:16 PM
To: Multiple recipients of list ORACLE-L
Subject: Bulkcopy

All,

Anyone heard of this utility for Oracle ?. Someone mentioned it today and I didn't have a clue. They said it would be in $ORACLE_HOME/bin. Nothing there !!

Regards

Lee
-- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Weaver, Walt INET: wweaver@rightnow.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@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).