| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Bulkcopy
<font size=2 color="#993366"
face=Arial><span style='font-size:10.0pt;mso-bidi-font-size:12.0pt;font-family:
Arial'>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 size=2 color="#993366"
face=Arial><span style='font-size:10.0pt;mso-bidi-font-size:12.0pt;font-family:
Arial'>
<!---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='font-family:Impact;color:#339966;
font-style:italic'>
<span
style='font-size:12.0pt;font-family:Impact;color:#339966;font-style:italic'>Bill
Carle
<span
style='font-size:12.0pt;font-family:"Century Gothic";color:#993366'>AT&T<font
color="#993366" face="Century Gothic"><span style='font-family:"Century Gothic";
color:#993366;mso-color-alt:windowtext'>
<span
style='font-size:12.0pt;font-family:"Century Gothic";color:#993366'>Database
Administrator<span
style='font-family:"Century Gothic";color:#993366;mso-color-alt:windowtext'>
<span
style='font-size:12.0pt;font-family:"Century Gothic";color:#993366'>816-995-3922<font
color="#993366" face="Century Gothic"><span style='font-family:"Century Gothic";
color:#993366;mso-color-alt:windowtext'>
<span
style='font-size:12.0pt;font-family:"Century Gothic";color:#993366'>wcarle_at_att.com<font
color="#993366" face="Century Gothic"><span style='font-family:"Century Gothic";
color:#993366;mso-color-alt:windowtext'>
<!---size:10.0pt;mso-bidi-font-size:
12.0pt;font-family:Arial'><span
class=EmailStyle19><span
style='font-size:10.0pt;mso-bidi-font-size:12.0pt;font-family:Arial'>
<font size=2 color=black
face=Tahoma>-----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
<span
style='font-size:12.0pt'>
<span
style='font-size:10.0pt;font-family:Arial;color:blue'>sqlldr. AT&T
obviously uses Sybase.<span style='color:black;
mso-color-alt:windowtext'>
<span
style='font-size:10.0pt;font-family:Arial;color:blue'> <font
color=black>
<p class=MsoNormal style='mso-margin-top-alt:0in;margin-right:0in;margin-bottom:
12.0pt;margin-left:.5in'><span
style='font-size:10.0pt;color:black'> -----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<font
size=2 color=black><span style='font-size:10.0pt;color:black;mso-color-alt:
windowtext'>
<font
size=2 color=navy face=Arial><span style='font-size:10.0pt;mso-bidi-font-size:
12.0pt;font-family:Arial'>Howdy,
<font
size=2 color=navy face=Arial><span style='font-size:10.0pt;mso-bidi-font-size:
12.0pt;font-family:Arial'>
<font
size=2 color=navy face=Arial><span style='font-size:10.0pt;mso-bidi-font-size:
12.0pt;font-family:Arial'>
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
size=2 color=navy face=Arial><span style='font-size:10.0pt;mso-bidi-font-size:
12.0pt;font-family:Arial'>
<!---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='font-family:Impact;color:#339966;
font-style:italic'>
<font size=3 color="#339966"
face=Impact><span style='font-size:12.0pt;font-family:Impact;color:#339966;
font-style:italic'>Bill Carle
<font size=3 color=navy
face="Century Gothic"><span style='font-size:12.0pt;font-family:"Century Gothic";
color:navy'>AT&T<span
style='font-family:"Century Gothic";color:black;mso-color-alt:windowtext'>
<font size=3 color=navy
face="Century Gothic"><span style='font-size:12.0pt;font-family:"Century Gothic";
color:navy'>Database Administrator<font color=black
face="Century Gothic"><span style='font-family:"Century Gothic";color:black;
mso-color-alt:windowtext'>
<font size=3 color=navy
face="Century Gothic"><span style='font-size:12.0pt;font-family:"Century Gothic";
color:navy'>816-995-3922<span
style='font-family:"Century Gothic";color:black;mso-color-alt:windowtext'>
<font size=3 color=navy
face="Century Gothic"><span style='font-size:12.0pt;font-family:"Century Gothic";
color:navy'>wcarle_at_att.com<span
style='font-family:"Century Gothic";color:black;mso-color-alt:windowtext'>
<!---size:
10.0pt;mso-bidi-font-size:12.0pt;font-family:Arial'><span style='mso-element:
field-end'><font
size=2 color=navy face=Arial><span style='font-size:10.0pt;mso-bidi-font-size:
12.0pt;font-family:Arial'>
<font size=2 color=black
face=Tahoma>-----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<font
color=black>
<font size=3 color=black
face="Times New Roman"> <font
color=black>
<font size=2 color=black
face=Arial>All,<font
color=black>
<font size=3 color=black
face="Times New Roman"> <font
color=black>
<font size=2 color=black
face=Arial>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 !!<font
color=black>
<font size=3 color=black
face="Times New Roman"> <font
color=black>
<font size=2 color=black
face=Arial>Regards<font
color=black>
<font size=3 color=black
face="Times New Roman"> <font
color=black>
<font size=2 color=black
face=Arial>Lee<font
color=black>
<span style='font-size:12.0pt;
color:black'> <span style='color:black;
mso-color-alt:windowtext'>
<font size=3 color=black
face="Courier New"><span style='font-size:12.0pt;font-family:"Courier New";
mso-fareast-font-family:"Courier New";color:black'>
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.<font
color=black>
Received on Mon May 21 2001 - 13:41:30 CDT
 |
 |