Sqlloader-problem

From: <Roland.Skoldblom_at_ica.se>
Date: Mon, 01 Oct 2001 00:10:45 -0700
Message-ID: <F001.0039D156.20010930234019@fatcity.com>

Hallo all you DBA's,

Can anyone give me some examples on how to do this:

I want a sqlloader to run, the sqlloader is doing an insert into a table(TABLE1) from a text file, immediately, after the insert into tthe table, there will be an insert into another table(TABLE2) with data from TABLE1. Give me a good example of this.

I also want the sqlloader to run at a certain clock time, let us say 2 am(at night).. Iam running from unix.

Would appreciate this if you could help me with these steps.

Thanks in advance.

Roland Sköldblom

--

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

Author:
  INET: Roland.Skoldblom_at_ica.se

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_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 Mon Oct 01 2001 - 02:10:45 CDT