From teci@the-testas.net Fri, 31 Aug 2001 03:54:15 -0700 From: Joe Testa Date: Fri, 31 Aug 2001 03:54:15 -0700 Subject: Re: Sqlldr-help Message-ID: MIME-Version: 1.0 Content-Type: text/plain look in the sqlldr docs for example control files, 1. truncate is a keyword for control file 2. load data 3. create trigger to do the insert into another table. Roland.Skoldblom@ica.se wrote: > > Hallo, > > Can anyone give me an example on a control.file for th esql ldr that does the >following: > Truncate table X inthe database > Loads data into table X > Makes an insert from that table into another table in the database. > And of course commit statement afterwards > > Thanks in advance > > Roland S > -- Joe Testa My EMAILS to oracle-l, not giving you the answer but helping you to find it yourself. IM: n8xcthome or joen8xct -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joe Testa INET: teci@the-testas.net 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@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).