Home -> Usenet -> comp.databases.oracle -> Insert records from table 1 to table 2

Insert records from table 1 to table 2

From: Jay <jlee00_99_at_yahoo.com>
Date: 14 Mar 2003 08:26:16 -0800
Message-ID: <3ea71bf0.0303140826.2b8cdd3e_at_posting.google.com> 






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
Received on Fri Mar 14 2003 - 17:26:16 CET












Original text of this message