RE: Loading a flat file into Oracle
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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
RE: Loading a flat file into Oracle
Santosh, The Oracle Utilities manual is not bad either, it explains sqlldr and export and import, all database utilities that come with the database. Find it at the Oracle web site if you don't have a copy. I suggest you look at sqlloader. There are some good pages on the FAQ associated with this site 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 Don Malzahn, IT/AS, Harper Community College Voice:(847) 925-6829 E-mail: [EMAIL PROTECTED]Web page: http://www.harper.cc.il.us The only limit to our realization of tomorrow will be our doubts of today. - FDR -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Don Malzahn INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
RE: Loading a flat file into Oracle
Thanks to all and one who replied to me. santosh -Original Message- [EMAIL PROTECTED] 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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
