Return-Path: Received: from ensim.rackshack.net (root@localhost) by orafaq.net (8.11.6/8.11.6) with ESMTP id g9AJS7L07031 for ; Thu, 10 Oct 2002 14:28:07 -0500 X-ClientAddr: 209.68.248.164 Received: from newsfeed.cts.com (newsfeed.cts.com [209.68.248.164]) by ensim.rackshack.net (8.11.6/8.11.6) with ESMTP id g9AJS7D07026 for ; Thu, 10 Oct 2002 14:28:07 -0500 Received: from fatcity.UUCP (uucp@localhost) by newsfeed.cts.com (8.9.3/8.9.3) with UUCP id KAA44145; Thu, 10 Oct 2002 10:09:38 -0700 (PDT) Received: by fatcity.com (26-Feb-2001/v1.0g-b72/bab) via UUCP id 004E5D45; Thu, 10 Oct 2002 08:53:58 -0800 Message-ID: Date: Thu, 10 Oct 2002 08:53:58 -0800 To: Multiple recipients of list ORACLE-L X-Comment: Oracle RDBMS Community Forum X-Sender: Don Malzahn Sender: root@fatcity.com Reply-To: ORACLE-L@fatcity.com Errors-To: ML-ERRORS@fatcity.com From: Don Malzahn Subject: RE: Loading a flat file into Oracle Organization: Fat City Network Services, San Diego, California X-ListServer: v1.0g, build 72; ListGuru (c) 1996-2001 Bruce A. Bergman Precedence: bulk Mime-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII Content-Transfer-Encoding: 7bit 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: dmalzahn@harper.cc.il.us 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: dmalzahn@harper.cc.il.us 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@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).