Re: Importing data
From: Sigrid Staudte <mstaudte_at_rz.uni-leipzig.de>
Date: 1997/12/02
Message-ID: <348481DB.17598DF2_at_rz.uni-leipzig.de>#1/1
Date: 1997/12/02
Message-ID: <348481DB.17598DF2_at_rz.uni-leipzig.de>#1/1
Casper Thrane wrote:
> Is it possible to import/update data automaticly with the sql*loader or
> any other programs?
If your operating system is unix you have to
- write an parameterfile for the sql*loader
- than you have to write an executable shellscript, which sets the nessesary required environment,connects to the database, starts the sqlldr with <parameterfile> and, after loading, diconnects from database.
- you have to fix the date, time,.. for execution of the script with the crontab-command
By...Sigrid Received on Tue Dec 02 1997 - 00:00:00 CET