Re: use of SQL*Loader on the workstation side

sqlloader is included in the ordinary Oracle client in the server utilities section (which doesn't say it MUST run on the server). There's no problem in installing it on workstations. Installing Personal Oracle would mean installing n databases. You probably don't want that.

Hth,

Sybrand Bakker, Oracle DBA

Pierre Labrecque <pierre.labrecque_at_pobox.com> wrote in message news:Pwzt4.2075$pf4.103102_at_news20.bellglobal.com...
> Hi everyone,
>
> I am new in the world of Oracle and I have an easy question for you.
>
> I have two workstations that will access an Oracle database located on a
> server through Oracle Discoverer 3.1. Users will have to populate the
> database with ASCII flat files.
>
> These flat files are easy to upload into the database, using SQL*Loader,
> when the user is logged on the server. However, we would like the user to
be
> able to populate the database from a workstation.
>
> Is there way to call the SQL*Loader from the workstation?
>
> Or
>
> If we install Oracle Personal edition on the workstation (assuming that
this
> version comes with SQL*Loader) can we populate the database located on the
> server for the workstation?
>
> Or
>
> Any other suggestions.
>
> thanks,
>
> Pierre
>
>
>
>
Received on Fri Feb 25 2000 - 13:45:18 CST