Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Importing data

Re: Importing data

From: Sigrid Staudte <mstaudte_at_rz.uni-leipzig.de>
Date: 1997/12/02
Message-ID: <348481DB.17598DF2@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

  1. write an parameterfile for the sql*loader
  2. 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.
  3. 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 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US