SQL*Loader PARFILE Parameter

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
DBA Tips Data Pump Reference

0 comments:

Post a Comment

 

dba topics. Copyright 2011-16 All Rights Reserved | Site Map | Contact | Disclaimer | Google