advertisements
_____________________________________________________________________________________________________________________
There are 2 ways to
specify the parameters to the SQL* loader-command line and parameter file.
Suppose if you are running the SQL* loader through command line by giving the
credentials you cannot hide the password from the process list (ps –ef). Also,
if you have more number of parameters needs to specified with the SQL* loader
in that case there are some limitations for the command prompt.
To satisfy those
above conditions you can use the parfile option to specify the SQL*
loader options.
Whichever commands
needs to be specified with the SQL* loader, add those parameters to a flat file
and call that file with SQL* Loader with parfile parameter. See some examples
below.
a.
Content of parfile
$ cat ldr.par
userid=sthomas/tiger
control=/home/oracle/st/sqlload.ctl
errors=1000
log=sqlldr.log
b.
Invoking the
sqlloader.
$ sqlldr
parfile=ldr.par
SQL*Loader: Release
11.2.0.3.0 - Production on Wed Jul 24 08:13:35 2013
Copyright (c) 1982,
2011, Oracle and/or its affiliates. All
rights reserved.
Commit point reached
- logical record count 8
_____________________________________________________________________________________________________________________
0 comments:
Post a Comment