SQL*Loader PARFILE Parameter



The Eucharistic Miracles of the World
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

b.   Invoking the sqlloader.
$ sqlldr parfile=ldr.par

SQL*Loader: Release - 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


Website Stats


Post a Comment


Oracle (629) Script (86) General (77) Unix (47) Blog (23) Technology (19) gadget (6) games (6) Business (3) OCI (3) SQL* Loader (3) Datapump (2)

acehints.com Copyright 2011-23 All Rights Reserved | Site Map | Contact | Disclaimer