OT RE: Load a textfile

2001-05-15 Thread Mohan, Ross
ep, please send me a mail like that sometime! rm || -Original Message- || From: Eric D. Pierce [mailto:[EMAIL PROTECTED]] || Sent: Tuesday, May 15, 2001 6:11 PM || To: Multiple recipients of list ORACLE-L || Subject: RE: Load a textfile || || || A., || || That's what I thought

RE: Load a textfile

2001-05-15 Thread Eric D. Pierce
A., That's what I thought, but I wanted to remain open to celebrating the positive possibility of a nurturing, benovolent universe were rational behavior is unconstrained by the vagaries and vicissitudes of the dark side of the farce. Or maybe I was hoping that I'd get a secret, mystical decod

RE: Load a textfile

2001-05-15 Thread A. Bardeen
Eric, AFAIK, all of the manuals are not available at http://docs.oracle.com Mainly installation and client manuals along with a smattering of other manuals for which I haven't quite figured out the rationale determining their inclusion. In any event, your best bet is either technet or metalink.

RE: Load a textfile

2001-05-15 Thread Eric D. Pierce
http://otn.oracle.com/doc/server.804/a58244/ch04.htm (free registration still required?) ps, I have *not* been able to figure out how to get to the _Utilities Manual_ on http://docs.oracle.com , which is *very* annoying. On 15 May 2001, at 7:10, Mark Leith wrote: Date sent:

RE: Load a textfile

2001-05-15 Thread Mark Leith
Roland, SQL*Loader can do this, you will need to create a control file specifying FIELDS TERMINATED BY ';' and the fields you would like to import - something like: copy to .ctl file in notepad- LOAD DATA INFILE 'path/to/your/file/file_name.txt' < Your text file [INSERT]/[AP