RE: Bulkcopy

2001-05-22 Thread Robertson Lee - lerobe
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

RE: Bulkcopy

2001-05-22 Thread Thater, William
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

RE: Bulkcopy

2001-05-22 Thread Glenn Travis
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

RE: RE: Bulkcopy

2001-05-22 Thread Weaver, Walt
- 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

Re:RE: RE: Bulkcopy

2001-05-22 Thread dgoulet
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:

RE: RE: Bulkcopy

2001-05-22 Thread Robertson Lee - lerobe
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

RE: RE: Bulkcopy

2001-05-22 Thread Glenn Travis
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

Re: Bulkcopy

2001-05-22 Thread Bill Pribyl
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

RE: Bulkcopy

2001-05-21 Thread Carle, William T (Bill), NLCIO
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]

Re: Bulkcopy

2001-05-21 Thread Rachel Carmichael
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

RE: Bulkcopy

2001-05-21 Thread Mohan, Ross
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

RE: Bulkcopy

2001-05-21 Thread Glenn Travis
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

RE: Bulkcopy

2001-05-21 Thread Rachel Carmichael
-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

RE: Bulkcopy

2001-05-21 Thread Carle, William T (Bill), NLCIO
] -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

RE: Bulkcopy

2001-05-21 Thread Christopher Spence
: 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

RE: Bulkcopy

2001-05-21 Thread Christopher Spence
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

OT RE: Bulkcopy

2001-05-21 Thread Mohan, Ross
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

RE: Bulkcopy

2001-05-21 Thread Rachel Carmichael
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

RE: Bulkcopy

2001-05-21 Thread Deshpande, Kirti
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

RE: Bulkcopy

2001-05-21 Thread Rachel Carmichael
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

RE: Bulkcopy

2001-05-21 Thread Rachel Carmichael
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

RE: Bulkcopy

2001-05-21 Thread Thater, William
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

2001-05-21 Thread Kimberly Smith
: 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

RE: Bulkcopy

2001-05-21 Thread Christopher Spence
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