RE: RE: Bulkcopy

From: Glenn Travis <c-glenn.travis_at_wcom.com>
Date: Tue, 22 May 2001 14:58:02 -0700
Message-ID: <F001.0030B771.20010522142042@fatcity.com>

You may be thinking of dbload. Informix also has ipload (high performance loader). onunload and onload are used for unloading and loading binary copies of the database (consistent copy). Docs can be found here --> http://www.informix.com/answers/english/product1.htm for all product versions.

-----Original Message-----
Lee - lerobe
Sent: Tuesday, May 22, 2001 9:47 AM
To: Multiple recipients of list ORACLE-L

Apologies if my ailing memory doesn't serve me correctly but is the Informix utility LOAD/UNLOAD from/to OS files. I do sort of remember using that when I had Informix DBs to look after as well as Oracle but it was a good 2-3 years ago now.

-----Original Message-----
Sent: 22 May 2001 16:57
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 <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><!--[if gte mso 9]><xml>
<w:WordDocument>

  <w:Zoom>0</w:Zoom>
  <w:DocumentKind>DocumentEmail</w:DocumentKind>
  <w:EnvelopeVis/>

</w:WordDocument>
</xml><![endif]-->
<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><SPAN
class=400281417-22052001>apologies.  no offense was intended.</DIV>
<DIV><SPAN
class=400281417-22052001> </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>
 <FONT color=#993366 face=Arial

size=2>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> <FONT color=#993366 face=Arial

size=2><![if
!supportEmptyParas]> <![endif]><o:p></o:p> <!--[if supportFields]><span

style="mso-spacerun: yes"> AUTOTEXTLIST \s "E-mail Signature" <![endif]-->
<

FONT
 color=#339966 face=Impact><o:p></o:p> Bill
 Carle<o:p></o:p> AT&T<o:p></o:p> Database
 Administrator<SPAN

style="COLOR: #993366; FONT-FAMILY: 'Century Gothic'; mso-color-alt: windowtext"><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: 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
 <FONT face="Times New Roman"

size=3><![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 Subject: RE: Bulkcopy<o:p></o:p> <FONT

color=navy face=Arial size=2>Howdy,<o:p></o:p> <FONT

color=navy face=Arial size=2>    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> <FONT color=black face=Arial

size=2>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> <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 !!<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> <FONT color=black face=Arial

size=2>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> <FONT color=black face=Arial

size=2>Lee<o:p></o:p>

--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Robertson Lee - lerobe
  INET: lerobe_at_acxiom.co.uk

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_at_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).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Glenn Travis
  INET: c-glenn.travis_at_wcom.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_at_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).

Received on Tue May 22 2001 - 16:58:02 CDT