RE: Loading a flat file into Oracle

From: Santosh Varma <vsantosh_at_psi.soft.net>
Date: Thu, 10 Oct 2002 21:13:21 -0800
Message-ID: <F001.004E67BC.20021010211321@fatcity.com>

Thanks to all and one who replied to me.

santosh

-----Original Message-----

moyam_at_mtn.co.ug
Sent: Thursday, October 10, 2002 7:34 PM To: Multiple recipients of list ORACLE-L

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).

--

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

Author: Santosh Varma
  INET: vsantosh_at_psi.soft.net

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 Fri Oct 11 2002 - 00:13:21 CDT