Re: Insert records from table 1 to table 2

You can do following:

INSERT INTO TABLE1
SELECT * FROM TABLE2;
COMMIT; now save above sql command as .sql on unix and call that script from unix shell script (i.e. load_tables.sh) aand schedule that shell script to run in cron. Cron examples can be found on unix by typing "man crontab". Add cron job by using command "crontab -e". Hope this helps.

Frank <fvanbortel_at_netscape.net> wrote in message news:<3E722A56.5080706_at_netscape.net>...
> Jay wrote:
> > I have a table that I'de like to on a daily basis extract data from
> > and load that data into another table. However, I need this process to
> > take place automatically once each day. My Oracle database is on a
> > Unix box. I know I will have to write SQL or PL/SQL, but what will I
> > need to do to schedule my SQL to execute automatically once each day.
> > I've seen places where they have used Cron to schedule batch jobs to
> > run.
> >
> > Any suggestions or pointers to accomplish this task would help.
> >
> > Thanks,
> >
> > Jay
>
> dbms_job package.
Received on Mon Mar 17 2003 - 23:18:29 CET