Why would you require the current directory to be passed to SQL*Loader?

The control file used by SQL*Loader can be generated (or modified)
by your shell script and it can modify the 'INFILE' clause to have
the appropriate directory name and input file name.

-----Original Message-----
From: Pitchai Siva (GE Infra Energy Non-GE)
[mailto:oracledba-ezmlmshield-x6879626.[Email address protected]
Sent: Monday, March 31, 2008 5:55 AM
To: LazyDBA Discussion
Subject: is there any way to pass the UNIX variable to SQL *Loader.

Hi all,



I've created one shell script it's called the sql loader for load the
flat file into DB table. The flat file has been created by UNIX shell
script.

I wanted to pass the UNIX current directory to the sql loader (I have
assigned the current DIR into one variable) so I want to pass the
variable to sql loader. How can I do it...?







Thanks and regards,

Siva.P

Bangalore





---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To Subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html



Oracle LazyDBA home page