Spot
on with every assumption Bill.
PS.
Thanks to everyone else who responded.
Regards
Lee
-Original
Message-From: Carle, William T (Bill), NLCIO
[mailto:[EMAIL PROTECTED]]Sent: 21 May 2001 20:45To:
Multiple recipients of list ORACLE-LSubject: RE:
Bulkcopy
On Mon, 21 May 2001,Christopher Spence scribbled on the wall in glitter crayon:
- Oh boy :)
-
- I can see that as a seal or a hunting while kegging but last time I got
-shot at is when I was playing paint ball (13 balls/s x 130MPH is pretty
-nasty). Colleages are kind of afraid what would
the references at this time. Anyone have more
info?
-Original Message-From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]]On Behalf Of Carle, William T (Bill),
NLCIOSent: Monday, May 21, 2001 12:45 PMTo: Multiple
recipients of list ORACLE-LSubject: RE:
Bulkcopy
ATT
uses
-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]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
ATT uses Oracle. I'm well acquainted with sqlldr, and I assumed that the
questioner was too. I
Walt,
I'm going to refrain from sendign teh enire thread as it's getting BIG.
Ahyhow, No it will not be retrofitted to Oracle 8/8I. And it may or may not
be totally functional in 9.0.
Dick Goulet
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
INET:
info?
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]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
ATT uses Oracle. I'm well acquainted with sqlldr, and I
recipients of list ORACLE-L
Subject: RE: Bulkcopy
ATT 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
ATT
Database
The 9i feature is apparently called external tables and there is a publicly
available mention of it here:
http://technet.oracle.com/products/oracle9i/htdocs/9ipak/bi/etl/etl.html#ExternalTables
Bill
[EMAIL PROTECTED] wrote:
Glenn,
At the last NorthEast Oracle Users Group meeting we
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 dont know of any such command in
Oracle.
Bill
Carle
ATT
Database
Administrator
816-995-3922
[EMAIL PROTECTED]
Bulkcopy is a Sybase utility. You can do bulk loading via sqlldr and the
only way to do bulk extract in a readable format is to use sql*plus or some
other program.
From: Robertson Lee - lerobe [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL
like sqlldr (flat==dbms) and data unloader (raw dbf==ascii dml)?
Rachel knows alot about this. Has a few medals in the Great Data
Wars of the Last Millenium.
-Original Message-
Sent: Monday, May 21, 2001 2:46 PM
To: Multiple recipients of list ORACLE-L
Howdy,
The only
sqlldr. ATT obviously uses
Sybase.
-Original Message-From:
[EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Carle, William T
(Bill), NLCIOSent: Monday, May 21, 2001 11:46 AMTo:
Multiple recipients of list ORACLE-LSubject: RE:
Bulkcopy
Howdy,
The only bulkcopy
-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: RE: Bulkcopy
Date: Mon, 21 May 2001 11:05:59 -0800
like sqlldr (flat==dbms) and data unloader (raw dbf==ascii dml)?
Rachel knows alot about this. Has a few medals in the Great Data
Wars of the Last Millenium
]
-Original
Message-
From: Glenn Travis
[mailto:[EMAIL PROTECTED]]
Sent: Monday, May 21, 2001 2:20 PM
To: Multiple recipients of list
ORACLE-L
Subject: RE: Bulkcopy
sqlldr. ATT
obviously uses Sybase.
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]]On Behalf
: Carle, William T (Bill),
NLCIO [mailto:[EMAIL PROTECTED]]Sent: Monday, May 21, 2001 3:45
PMTo: Multiple recipients of list ORACLE-LSubject: RE:
Bulkcopy
ATT
uses Oracle. Im well acquainted with sqlldr, and I assumed that the
questioner was too. I took his question
ORACLE-L [EMAIL PROTECTED]
Subject: RE: Bulkcopy
Date: Mon, 21 May 2001 11:05:59 -0800
like sqlldr (flat==dbms) and data unloader (raw dbf==ascii dml)?
Rachel knows alot about this. Has a few medals in the Great Data
Wars of the Last Millenium.
-Original Message-
Sent: Monday, May 21, 2001 2
maybe we can crAck it with a LoPht tRoJaN Horse Warez Vye-rus?
|| -Original Message-
|| From: Christopher Spence [mailto:[EMAIL PROTECTED]]
|| Sent: Monday, May 21, 2001 4:01 PM
|| To: Multiple recipients of list ORACLE-L
|| Subject: RE: Bulkcopy
||
||
|| Oh yeah, and they kick you out
files
:)
From: Christopher Spence [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: RE: Bulkcopy
Date: Mon, 21 May 2001 12:00:55 -0800
Oh yeah, and they kick you out of the room when they do it.
They also purge the filesystem so you
To: Multiple recipients of list ORACLE-L
Subject: RE: Bulkcopy
There is a tool you can do to convert a table to CSV on Thomas Kyte's
page, there is also a product from Oriole called PDQ Out which will output
tables into format that can be blasted in with SQL LOADER. I would also
look
bcp will extract to readable format, unlike import/export
From: Deshpande, Kirti [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: RE: Bulkcopy
Date: Mon, 21 May 2001 12:45:50 -0800
From what I know, bulk copy or bcp
PROTECTED]
Subject: RE: Bulkcopy
Date: Mon, 21 May 2001 13:16:55 -0800
I have never had to do it personally, but i have heard a few stories.
-Original Message-
Sent: Monday, May 21, 2001 4:32 PM
To: Multiple recipients of list ORACLE-L
hm, maybe I smiled nicer at the tech than you, I got
On Mon, 21 May 2001,Rachel Carmichael scribbled on the wall in glitter crayon:
-I have had to it is not one of my more favorite memories...
-
-I don't LIKE going 40 hours without sleep
-
-and after a while, diet Coke just doesn't have an effect :)
You just need people shooting at you from
: RE: Bulkcopy
Date: Mon, 21 May 2001 13:16:55 -0800
I have never had to do it personally, but i have heard a few stories.
-Original Message-
Sent: Monday, May 21, 2001 4:32 PM
To: Multiple recipients of list ORACLE-L
hm, maybe I smiled nicer at the tech than you, I got to stay
Oh boy :)
I can see that as a seal or a hunting while kegging but last time I got
shot at is when I was playing paint ball (13 balls/s x 130MPH is pretty
nasty). Colleages are kind of afraid what would happen to the database if I
got shot.
-Original Message-
To: Multiple recipients
24 matches
Mail list logo