Re: use of SQL*Loader on the workstation side

From a DOS prompt type

sqlldr80 PARFILE=<par file path\file> DATA=<data file path>

The par file specifies parameters specified at run time;

 USERID=FOO/FOO_at_FOO.WORLD
CONTROL=C:\MyDocu~1\LdGrpStg.Ctl
    LOG=C:\MyDocu~1\LdGrpStg.Log
    BAD=C:\MyDocu~1\LdGrpStg.Bad
 ERRORS=999999

Read up on the loader and this will all make sense. We use these commands in a DOS batch file to load data from our mainframe.

On Fri, 25 Feb 2000 18:06:39 GMT, "Pierre Labrecque" <pierre.labrecque_at_pobox.com> wrote:

>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 Wed Mar 08 2000 - 20:03:08 CST