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

Home -> Community -> Usenet -> c.d.o.misc -> Re: use of SQL*Loader on the workstation side

Re: use of SQL*Loader on the workstation side

From: Stephen Pennine <spennine_at_home.com>
Date: Thu, 09 Mar 2000 02:03:08 GMT
Message-ID: <q81ecso8i6rok0rpgp2rc1clq5tm0ugbim@4ax.com>


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

Original text of this message

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