RE: Loading a flat file into Oracle

From: <moyam_at_mtn.co.ug>
Date: Thu, 10 Oct 2002 06:03:41 -0800
Message-ID: <F001.004E5914.20021010060341@fatcity.com>

You have got SQLLoader example scripts on your PC/laptop on which Oracle is installed.

Check out C:\ORACLE\ORA81\RDBMS\DEMO on your Windows Installation. You will find scripts names UTCASEn.CTL.

Edit these scripts to relfect your destination table, fields and you will be done.

Moses Moya

-----Original Message-----
Sent: Thursday, October 10, 2002 2:44 PM To: Multiple recipients of list ORACLE-L

Santosh.
Putting a subject on your e-mails is useful to everyone  

I suggest you look at sqlloader. There are some good pages on the FAQ associated with this site
http://www.orafaq.com <http://www.orafaq.com>  

HTH   John

-----Original Message-----
Sent: 10 October 2002 11:59
To: Multiple recipients of list ORACLE-L

Hello all,  

      I have a client who will be doing the data capture and give me the data in a flat file.
what i need to do in oracle is load from that flat file to my database. any scripts available ?? please send me across. ASAP....

Thanks and regards,

Santosh

--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author:
  INET: John.Hallas_at_vodafone.co.uk

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------

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:
  INET: moyam_at_mtn.co.ug

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------

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 Thu Oct 10 2002 - 09:03:41 CDT