RE: Sqloader

From: Koivu, Lisa <lisa.koivu_at_efairfield.com>
Date: Mon, 01 Oct 2001 08:08:52 -0700
Message-ID: <F001.0039D6C7.20011001073020@fatcity.com>

Also, depending on what version you are on, you can have multiple INTO TABLE statements.  See below from the 8.1.7 doco.

Using Multiple INTO TABLE Statements

Multiple INTO TABLE statements allow you to: Load data into different tables
Extract multiple logical records from a single input record Distinguish different input record formats

In the first case, it is common for the INTO TABLE statements to refer to the same table. This section illustrates the different ways to use multiple INTO TABLE statements and shows you how to use the POSITION keyword.

Note: A key point when using multiple INTO TABLE statements is that field scanning continues from where it left off when a new INTO TABLE statement is processed. The remainder of this section details important ways to make use of that behavior. It also describes alternative ways using fixed field locations or the POSITION keyword.

Lisa Koivu
Oracle Database Administrator
Fairfield Resorts, Inc.
954-935-4117

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

From:   Dennis M. Heisler [SMTP:dheisler_at_binghamton.edu]
Sent:   Monday, October 01, 2001 10:10 AM
To:     Multiple recipients of list ORACLE-L

Subject:        Re: Sqloader

Just create a shell script which first calls sqlloader to populate table 1, then calls a sql script to populate table2.  Schedule it with a cron job.

Dennis

Roland.Skoldblom_at_ica.se wrote:
>
> 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).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Dennis M. Heisler
  INET: dheisler_at_binghamton.edu


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 - 10:08:52 CDT