Re: NEED HELP ON SQL LOADER

refer to the oracle utilities guide for details on sqlldr.

as far as running this job once per week, you can set up a script to run sqlldr with all the pertinent information in a ctl file, then use cron to administrate running the job as required. just do a man on cron and crontab.

miguel wrote:
>
> FIREWALL <ubsram_at_pacific.net.sg> wrote in article
> <344cc1ff.3358308_at_news.pacific.net.sg>...
> > Dear Friends,
> >
> > I need help on SQL Loader. How do I load ASCII files from UNIX to
> > Oracle Database 7 using SQL Loader.
> >
> > Please help me with the syntax.
>
> % SQLLDR username/password,
> ´....../test.ctl´,´....../test.log',´.....test.bad',' ...../test.txt´
>
> Where test.txt is the file to be load,like:
> lisboa,10
> porto,20
>
> and test.ctl:
>
> load data
> into table test
> ( a char terminated by ",",
> b integer external terminated by ",")
>
> Miguel
> Portugal
>
> >
> > In addition, how do I schedule a job to be run on a weekly basis in
> > UNIX AIX ??
> >
> >
> > Please e-mail
> >
> > ubsram_at_pacific.net.sg
> >
> >
> > Thank you
> >
  Received on Wed Oct 22 1997 - 00:00:00 CDT