I suggest that for the first part, you read the Oracle docs on triggers
and add an "after insert" trigger on the first table to load the second
table.
As for the timing of when the job runs:
at a unix prompt type
man cron and read the documentation on setting up a crontab file
- 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).
Do You Yahoo!?
Listen to your Yahoo! Mail messages from any phone.
http://phone.yahoo.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Rachel Carmichael
INET: wisernet100_at_yahoo.com
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 - 09:59:08 CDT