Re:RE: Bulkcopy

From: <dgoulet_at_vicr.com>
Date: Tue, 22 May 2001 08:17:22 -0700
Message-ID: <F001.0030AD43.20010522075633@fatcity.com>

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 <c-glenn.travis_at_wcom.com>
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_at_fatcity.com [mailto:root_at_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_at_att.com

  -----Original Message-----
  From: Glenn Travis [mailto:c-glenn.travis_at_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_at_fatcity.com [mailto:root_at_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_at_att.com

  -----Original Message-----
  From: Robertson Lee - lerobe [mailto:lerobe_at_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.

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN"> <HTML xmlns="http://www.w3.org/TR/REC-html40" xmlns:o = "urn:schemas-microsoft-com:office:office" xmlns:w = "urn:schemas-microsoft-com:office:word"><HEAD>

<META content="text/html; charset=iso-8859-1" http-equiv=Content-Type>
<META content=Word.Document name=ProgId>
<META content="MSHTML 5.00.3314.2100" name=GENERATOR>
<META content="Microsoft Word 9" name=Originator><LINK

href="cid:filelist.xml_at_01C0E1FC.2DB8D530" rel=File-List>
<STYLE>@font-face {

font-family: Impact;
}
@font-face {

font-family: Century Gothic;
}
@font-face {

font-family: Tahoma;
}
P.MsoNormal {

FONT-FAMILY: "Times New Roman"; FONT-SIZE: 12pt; MARGIN: 0in 0in 0pt; mso-fareast-font-family: "Times New Roman"; mso-style-parent: ""; mso-pagination: widow-orphan
}
LI.MsoNormal {

FONT-FAMILY: "Times New Roman"; FONT-SIZE: 12pt; MARGIN: 0in 0in 0pt; mso-fareast-font-family: "Times New Roman"; mso-style-parent: ""; mso-pagination: widow-orphan
}
DIV.MsoNormal {

FONT-FAMILY: "Times New Roman"; FONT-SIZE: 12pt; MARGIN: 0in 0in 0pt; mso-fareast-font-family: "Times New Roman"; mso-style-parent: ""; mso-pagination: widow-orphan
}
P.MsoAutoSig {

FONT-FAMILY: "Times New Roman"; FONT-SIZE: 12pt; MARGIN: 0in 0in 0pt; mso-fareast-font-family: "Times New Roman"; mso-pagination: widow-orphan }
LI.MsoAutoSig {

FONT-FAMILY: "Times New Roman"; FONT-SIZE: 12pt; MARGIN: 0in 0in 0pt; mso-fareast-font-family: "Times New Roman"; mso-pagination: widow-orphan }
DIV.MsoAutoSig {

FONT-FAMILY: "Times New Roman"; FONT-SIZE: 12pt; MARGIN: 0in 0in 0pt; mso-fareast-font-family: "Times New Roman"; mso-pagination: widow-orphan }
P {

FONT-FAMILY: "Times New Roman"; FONT-SIZE: 12pt; MARGIN-LEFT: 0in; MARGIN-RIGHT: 0in; mso-margin-top-alt: auto; mso-fareast-font-family: "Times New Roman"; mso-pagination: widow-orphan; mso-margin-bottom-alt: auto }
CODE {
mso-fareast-font-family: "Courier New"; mso-ascii-font-family: "Courier New"; mso-hansi-font-family: "Courier New"; mso-bidi-font-family: "Courier New" }
SPAN.EmailStyle18 {

COLOR: navy; mso-ansi-font-size: 10.0pt; mso-ascii-font-family: Arial; mso-hansi-font-family: Arial; mso-bidi-font-family: Arial; mso-style-type: personal
}
SPAN.EmailStyle19 {

COLOR: #993366; mso-ansi-font-size: 10.0pt; mso-ascii-font-family: Arial; mso-hansi-font-family: Arial; mso-bidi-font-family: Arial; mso-style-type: personal-reply
}
DIV.Section1 {

page: Section1
}

</STYLE>
</HEAD>
<BODY lang=EN-US style="tab-interval: .5in">
<DIV><FONT color=#0000ff face=Arial size=2><SPAN

class=400281417-22052001>apologies.  no offense was intended.</DIV>
<DIV> </DIV> <DIV>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?</DIV>
<BLOCKQUOTE style="MARGIN-RIGHT: 0px">
<DIV class=OutlookMessageHeader>-----Original Message----- From: root_at_fatcity.com [mailto:root_at_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 </DIV>
<DIV class=Section1>
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.<o:p></o:p>
<![if !supportEmptyParas]> <![endif]><o:p></o:p>
< FONT
 color=#339966 face=Impact><o:p></o:p>
<SPAN
 style="COLOR: #339966; FONT-FAMILY: Impact; FONT-SIZE: 12pt; FONT-STYLE: italic">Bill
 Carle<o:p></o:p>
<SPAN
 style="COLOR: #993366; FONT-FAMILY: 'Century Gothic'; FONT-SIZE: 12pt">AT&T<o:p></o:p>
<SPAN
 style="COLOR: #993366; FONT-FAMILY: 'Century Gothic'; FONT-SIZE: 12pt">Database
 Administrator<o:p></o:p>
<SPAN
 style="COLOR: #993366; FONT-FAMILY: 'Century Gothic'; FONT-SIZE: 12pt">816-995-3922<o:p></o:p>
<SPAN
 style="COLOR: #993366; FONT-FAMILY: 'Century Gothic'; FONT-SIZE: 12pt">wcarle_at_att.com<o:p></o:p>
<![if !supportEmptyParas]> <![endif]><o:p></o:p>
-----Original Message----- From: Glenn Travis [mailto:c-glenn.travis_at_wcom.com] Sent: Monday, May 21, 2001 2:20 PM To: Multiple recipients of

list ORACLE-L Subject: RE: Bulkcopy
<![if !supportEmptyParas]> <![endif]><o:p></o:p>
sqlldr.  AT&T obviously uses Sybase.<o:p></o:p>
 <o:p></o:p>
 -----Original Message----- From: root_at_fatcity.com [mailto:root_at_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 <SPAN

  style="FONT-WEIGHT: bold">Subject:</SPAN></B> RE: Bulkcopy</SPAN></FONT><FONT 
  color=black size=2><SPAN 
  style="COLOR: black; FONT-SIZE: 10pt; mso-color-alt:

windowtext"><o:p></o:p>
<FONT
 color=navy face=Arial size=2>Howdy,<o:p></o:p>
<FONT
 color=navy face=Arial size=2><![if !supportEmptyParas]> <![endif]><o:p></o:p>
<FONT

  color=navy face=Arial size=2><SPAN 
  style="FONT-FAMILY: Arial; FONT-SIZE: 10pt; mso-bidi-font-size: 12.0pt"><SPAN 
  style="mso-spacerun: yes">&nbsp;&nbsp;&nbsp; </SPAN>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.<o:p></o:p>
<FONT
 color=navy face=Arial size=2><![if !supportEmptyParas]> <![endif]><o:p></o:p>
< FONT
 color=#339966 face=Impact><o:p></o:p>
<FONT color=#339966 face=Impact

size=3>Bill
 Carle<o:p></o:p>
AT&T<o:p></o:p>
Database Administrator<o:p></o:p>
816-995-3922<o:p></o:p>
wcarle_at_att.com<o:p></o:p>
<![if !supportEmptyParas]> <![endif]><o:p></o:p>
-----Original Message----- From: Robertson Lee - lerobe [mailto:lerobe_at_acxiom.co.uk] Sent: Monday, May 21, 2001 12:16 PM To: Multiple recipients of

list ORACLE-L Subject: Bulkcopy<o:p></o:p>
<![if !supportEmptyParas]> <![endif]><o:p></o:p>
All,<o:p></o:p>
<SPAN

  style="COLOR: black; FONT-SIZE: 12pt">&nbsp;</SPAN></FONT><FONT 
  color=black><SPAN 
  style="COLOR: black; mso-color-alt: windowtext"><o:p></o:p></SPAN></FONT></P>

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 !!<o:p></o:p>
<SPAN

  style="COLOR: black; FONT-SIZE: 12pt">&nbsp;</SPAN></FONT><FONT 
  color=black><SPAN 
  style="COLOR: black; mso-color-alt: windowtext"><o:p></o:p></SPAN></FONT></P>

Regards<o:p></o:p>
<SPAN

  style="COLOR: black; FONT-SIZE: 12pt">&nbsp;</SPAN></FONT><FONT 
  color=black><SPAN 
  style="COLOR: black; mso-color-alt: windowtext"><o:p></o:p></SPAN></FONT></P>

Lee<o:p></o:p>

<!doctype HTML PUBLIC><FONT

  color=black face="Times New Roman" size=3><SPAN 
  style="COLOR: black; FONT-SIZE: 12pt">&nbsp;</SPAN></FONT><FONT 
  color=black><SPAN 
  style="COLOR: black; mso-color-alt: windowtext"><o:p></o:p></SPAN></FONT></P>

 <CODE>The information

contained in this communication is</CODE> <CODE><SPAN

  style="mso-bidi-font-size: 12.0pt; mso-ansi-font-size: 12.0pt">confidential, 
  is intended only for the use of the recipient</SPAN></CODE><BR><CODE><SPAN 
  style="mso-bidi-font-size: 12.0pt; mso-ansi-font-size: 12.0pt">named above, 
  and may be legally privileged. If the reader </SPAN></CODE><BR><CODE><SPAN 
  style="mso-bidi-font-size: 12.0pt; mso-ansi-font-size: 12.0pt">of this message

is not the intended recipient, you are</CODE> <CODE>hereby notified

that any dissemination, distribution or</CODE> <CODE>copying of this

communication is strictly prohibited. </CODE> <CODE><SPAN

  style="mso-bidi-font-size: 12.0pt; mso-ansi-font-size: 12.0pt">If you have 
  received this communication in error, please </SPAN></CODE><BR><CODE><SPAN 
  style="mso-bidi-font-size: 12.0pt; mso-ansi-font-size: 12.0pt">re-send this

communication to the sender and delete the </CODE> <CODE>original message or any copy of it from your computer</CODE> <CODE>system.</CODE><o:p></o:p></DIV></BLOCKQUOTE></BODY></HTML> Received on Tue May 22 2001 - 10:17:22 CDT