RE: Bulkcopy

From: Glenn Travis <c-glenn.travis_at_wcom.com>
Date: Tue, 22 May 2001 07:28:05 -0700
Message-ID: <F001.0030AC26.20010522071632@fatcity.com>

<SPAN
class=400281417-22052001>apologies.  no offense was intended.
<SPAN
class=400281417-22052001> 
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?

<FONT face="Times New Roman"

  size=2>-----Original Message-----From: root_at_fatcity.com   [mailto:root_at_fatcity.com]On Behalf Of Carle, William T (Bill),   NLCIOSent: Monday, May 21, 2001 12:45 PMTo: Multiple   recipients of list ORACLE-LSubject: RE:   Bulkcopy   

<FONT color=#993366 face=Arial

  size=2><SPAN
  style="FONT-FAMILY: Arial; FONT-SIZE: 10pt; mso-bidi-font-size: 12.0pt">AT&T   uses Oracle. I&#8217;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=#993366 face=Arial

  size=2><SPAN
  style="FONT-FAMILY: Arial; FONT-SIZE: 10pt; mso-bidi-font-size: 12.0pt"> 
<!---size:10.0pt;mso-bidi-font-size:

12.0pt;font-family:Arial'><span
style="mso-spacerun: yes"> AUTOTEXTLIST \s "E-mail Signature" <FONT
  color=#339966 face=Impact><SPAN
  style="COLOR: #339966; FONT-FAMILY: Impact; FONT-STYLE: italic">
<SPAN

  style="COLOR: #339966; FONT-FAMILY: Impact; FONT-SIZE: 12pt; FONT-STYLE: italic">Bill   Carle
<SPAN

  style="COLOR: #993366; FONT-FAMILY: 'Century Gothic'; FONT-SIZE: 12pt">AT&T<FONT 
  color=#993366 face="Century Gothic"><SPAN 
  style="COLOR: #993366; FONT-FAMILY: 'Century Gothic'; mso-color-alt: windowtext">

<SPAN

  style="COLOR: #993366; FONT-FAMILY: 'Century Gothic'; FONT-SIZE: 12pt">Database   Administrator<SPAN
  style="COLOR: #993366; FONT-FAMILY: 'Century Gothic'; mso-color-alt: windowtext">
<SPAN

  style="COLOR: #993366; FONT-FAMILY: 'Century Gothic'; FONT-SIZE: 12pt">816-995-3922<FONT 
  color=#993366 face="Century Gothic"><SPAN 
  style="COLOR: #993366; FONT-FAMILY: 'Century Gothic'; mso-color-alt: windowtext">

<SPAN

  style="COLOR: #993366; FONT-FAMILY: 'Century Gothic'; FONT-SIZE: 12pt">wcarle_at_att.com<FONT 
  color=#993366 face="Century Gothic"><SPAN 
  style="COLOR: #993366; FONT-FAMILY: 'Century Gothic'; mso-color-alt: windowtext">

<!---size:10.0pt;mso-bidi-font-size:

12.0pt;font-family:Arial'><SPAN
  class=EmailStyle19><SPAN
  style="FONT-FAMILY: Arial; FONT-SIZE: 10pt; mso-bidi-font-size: 12.0pt"> 
<FONT color=black face=Tahoma

  size=2><SPAN
  style="COLOR: black; FONT-FAMILY: Tahoma; FONT-SIZE: 10pt">-----Original   Message-----From: Glenn
  Travis [mailto:c-glenn.travis_at_wcom.com]<SPAN   style="FONT-WEIGHT: bold">Sent: Monday, May 21, 2001 2:20   PMTo: Multiple recipients of
  list ORACLE-LSubject: RE:
  Bulkcopy
<FONT face="Times New Roman"

  size=3> 
<FONT color=blue face=Arial

  size=2><SPAN
  style="COLOR: blue; FONT-FAMILY: Arial; FONT-SIZE: 10pt">sqlldr.    AT&T obviously uses Sybase.<SPAN
  style="COLOR: black; mso-color-alt: windowtext">
<FONT color=blue face=Arial

  size=2><SPAN

  style="COLOR: blue; FONT-FAMILY: Arial; FONT-SIZE: 10pt"> <FONT 
  color=black><SPAN 
  style="COLOR: black; mso-color-alt: windowtext">

<P class=MsoNormal

  style="MARGIN-BOTTOM: 12pt; MARGIN-LEFT: 0.5in; MARGIN-RIGHT: 0in; mso-margin-top-alt: 0in"><FONT 
  color=black face="Times New Roman" size=2><SPAN 
  style="COLOR: black; FONT-SIZE: 10pt"> -----Original 

  Message-----From:
  root_at_fatcity.com [mailto:root_at_fatcity.com]<SPAN   style="FONT-WEIGHT: bold">On Behalf Of Carle, William T (Bill),   NLCIOSent: Monday, May 21,
  2001 11:46 AMTo: Multiple
  recipients of list ORACLE-L<SPAN

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

<FONT

  color=navy face=Arial size=2><SPAN
  style="FONT-FAMILY: Arial; FONT-SIZE: 10pt; mso-bidi-font-size: 12.0pt">Howdy,
<FONT

  color=navy face=Arial size=2><SPAN
  style="FONT-FAMILY: Arial; FONT-SIZE: 10pt; mso-bidi-font-size: 12.0pt"> 
<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">    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&#8217;t know of any such command   in Oracle.
<FONT

  color=navy face=Arial size=2><SPAN
  style="FONT-FAMILY: Arial; FONT-SIZE: 10pt; mso-bidi-font-size: 12.0pt"> 
<!---size:

10.0pt;mso-bidi-font-size:12.0pt;font-family:Arial'><span style='mso-element: field-begin'> AUTOTEXTLIST
\s "E-mail Signature" <FONT
  color=#339966 face=Impact><SPAN
  style="COLOR: #339966; FONT-FAMILY: Impact; FONT-STYLE: italic">
<FONT color=#339966 face=Impact

  size=3><SPAN
  style="COLOR: #339966; FONT-FAMILY: Impact; FONT-SIZE: 12pt; FONT-STYLE: italic">Bill   Carle
<FONT color=navy

  face="Century Gothic" size=3><SPAN

  style="COLOR: navy; FONT-FAMILY: 'Century Gothic'; FONT-SIZE: 12pt">AT&T<FONT 
  color=black face="Century Gothic"><SPAN 
  style="COLOR: black; FONT-FAMILY: 'Century Gothic'; mso-color-alt: windowtext">

<FONT color=navy

  face="Century Gothic" size=3><SPAN
  style="COLOR: navy; FONT-FAMILY: 'Century Gothic'; FONT-SIZE: 12pt">Database   Administrator<SPAN
  style="COLOR: black; FONT-FAMILY: 'Century Gothic'; mso-color-alt: windowtext">
<FONT color=navy

  face="Century Gothic" size=3><SPAN

  style="COLOR: navy; FONT-FAMILY: 'Century Gothic'; FONT-SIZE: 12pt">816-995-3922<FONT 
  color=black face="Century Gothic"><SPAN 
  style="COLOR: black; FONT-FAMILY: 'Century Gothic'; mso-color-alt: windowtext">

<FONT color=navy

  face="Century Gothic" size=3><SPAN

  style="COLOR: navy; FONT-FAMILY: 'Century Gothic'; FONT-SIZE: 12pt">wcarle_at_att.com<FONT 
  color=black face="Century Gothic"><SPAN 
  style="COLOR: black; FONT-FAMILY: 'Century Gothic'; mso-color-alt: windowtext">

<!---size:

10.0pt;mso-bidi-font-size:12.0pt;font-family:Arial'><span style='mso-element: field-end'><SPAN
  class=EmailStyle18><SPAN
  style="FONT-FAMILY: Arial; FONT-SIZE: 10pt; mso-bidi-font-size: 12.0pt"> 
<FONT color=black face=Tahoma

  size=2><SPAN
  style="COLOR: black; FONT-FAMILY: Tahoma; FONT-SIZE: 10pt">-----Original   Message-----From: Robertson
  Lee - lerobe [mailto:lerobe_at_acxiom.co.uk]<SPAN   style="FONT-WEIGHT: bold">Sent: Monday, May 21, 2001 12:16   PMTo: Multiple recipients of
  list ORACLE-LSubject:
  Bulkcopy<SPAN
  style="COLOR: black; mso-color-alt: windowtext">
<FONT color=black

  face="Times New Roman" size=3> <FONT
  color=black><SPAN
  style="COLOR: black; mso-color-alt: windowtext">
<FONT color=black face=Arial

  size=2><SPAN

  style="COLOR: black; FONT-FAMILY: Arial; FONT-SIZE: 10pt">All,<FONT 
  color=black><SPAN 
  style="COLOR: black; mso-color-alt: windowtext">

<FONT color=black

  face="Times New Roman" size=3><SPAN

  style="COLOR: black; FONT-SIZE: 12pt"> <FONT 
  color=black><SPAN 
  style="COLOR: black; mso-color-alt: windowtext">

<FONT color=black face=Arial

  size=2>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   !!<SPAN
  style="COLOR: black; mso-color-alt: windowtext">
<FONT color=black

  face="Times New Roman" size=3><SPAN

  style="COLOR: black; FONT-SIZE: 12pt"> <FONT 
  color=black><SPAN 
  style="COLOR: black; mso-color-alt: windowtext">

<FONT color=black face=Arial

  size=2><SPAN

  style="COLOR: black; FONT-FAMILY: Arial; FONT-SIZE: 10pt">Regards<FONT 
  color=black><SPAN 
  style="COLOR: black; mso-color-alt: windowtext">

<FONT color=black

  face="Times New Roman" size=3><SPAN

  style="COLOR: black; FONT-SIZE: 12pt"> <FONT 
  color=black><SPAN 
  style="COLOR: black; mso-color-alt: windowtext">

<FONT color=black face=Arial

  size=2><SPAN

  style="COLOR: black; FONT-FAMILY: Arial; FONT-SIZE: 10pt">Lee<FONT 
  color=black><SPAN 
  style="COLOR: black; mso-color-alt: windowtext">

<FONT

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

<FONT color=black

  face="Courier New" size=3><SPAN
  style="COLOR: black; FONT-FAMILY: 'Courier New'; FONT-SIZE: 12pt; mso-fareast-font-family: 'Courier New'"><SPAN   style="mso-bidi-font-size: 12.0pt; mso-ansi-font-size: 12.0pt">The information   contained in this communication is<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

  style="mso-bidi-font-size: 12.0pt; mso-ansi-font-size: 12.0pt">named above, 
  and may be legally privileged. If the reader <SPAN 
  style="mso-bidi-font-size: 12.0pt; mso-ansi-font-size: 12.0pt">of this message 

  is not the intended recipient, you are<SPAN   style="mso-bidi-font-size: 12.0pt; mso-ansi-font-size: 12.0pt">hereby notified   that any dissemination, distribution or<SPAN   style="mso-bidi-font-size: 12.0pt; mso-ansi-font-size: 12.0pt">copying of this   communication is strictly prohibited. <SPAN   style="mso-bidi-font-size: 12.0pt; mso-ansi-font-size: 12.0pt">If you have   received this communication in error, please <SPAN   style="mso-bidi-font-size: 12.0pt; mso-ansi-font-size: 12.0pt">re-send this   communication to the sender and delete the <SPAN   style="mso-bidi-font-size: 12.0pt; mso-ansi-font-size: 12.0pt">original   message or any copy of it from your computer<SPAN

  style="mso-bidi-font-size: 12.0pt; mso-ansi-font-size: 12.0pt">system.<FONT 
  color=black><SPAN 
  style="COLOR: black; mso-color-alt: windowtext">

Received on Tue May 22 2001 - 09:28:05 CDT