RE: load flat file to Oracle

dos prompt > copy *.csv all.csv

In the ctl file, use all.csv.?

p-

*>-----Original Message-----
*>From: root_at_fatcity.com [mailto:root_at_fatcity.com]On Behalf Of Jared Still
*>Sent: Tuesday, November 20, 2001 9:01 AM
*>To: Multiple recipients of list ORACLE-L
*>Subject: Fwd: load flat file to Oracle
*>
*>
*>
*>Sorry, can't help at the moment.
*>
*>Perhaps some of the esteemed members of the
*>list will have useful suggestions.
*>
*>Jared
*>
*>
*>---------- Forwarded Message ----------
*>Date: Tue, 20 Nov 2001 09:30:35 EST
*>To: <jkstill_at_cybcon.com>
*>
*>
*>Hi Jared,
*>Interesting web site.
*>Got a problem, I need to sql*load some flat files into a newly
*>created Oracle
*> table. The problem is that the files are around 180 (.csv) files and they
*> are currently on a directory on my machine. How do I handle
*>these many file
*> names in my (.ctl) program? Is there a way round this? I am
*>running Oracle
*> 8.1.7 on Windows 95 OS.
*>
*>Please can you help me?
*>
*>Thanks
*>
*>Deejay
*>
*>-------------------------------------------------------
*>--
*>Please see the official ORACLE-L FAQ: http://www.orafaq.com
*>--
*>Author: Jared Still
*> INET: jkstill_at_cybcon.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).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: ph
  INET: housholder_at_ualfltctr.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).