• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 737
  • Last Modified:

sql loader call

Is it possible to call an sqlloader control file from some script..say any shell scripts or batch scripts...Please explain in detail the possiblities..if you have examples then it would be much appreciated
0
suhinrasheed
Asked:
suhinrasheed
  • 2
  • 2
  • 2
1 Solution
 
popa_duhuCommented:
maybe this faq will help:
http://orafaq.com/faqloadr.htm
0
 
popa_duhuCommented:
what do you mean call the control file from a shell script ?

or you mean call sqlldr (with the control file as param) from a shell script ?
0
 
sujith80Commented:
The shell script would be as simple as:

# start of script

sqlldr user/pwd@host control=$1

# end of script

and you can call this script from the prompt as

$<script name> <control file name>


OR are you looking for something else?
0
Never miss a deadline with monday.com

The revolutionary project management tool is here!   Plan visually with a single glance and make sure your projects get done.

 
suhinrasheedAuthor Commented:
I am looking for creating a batch job that executes a Sql loader process?

Is it Possible..any examples
0
 
suhinrasheedAuthor Commented:
What i exactly want is that i have a sqloader process being called from a .bat file.
Now i want to know whether i can call this .bat file from an Oracle job.

My Oracle version is 9.2.0.7
0
 
sujith80Commented:
Calling that batch file from an Oracle Job - is not going to be straight forward. You will have to write a Java Stored procedure to make that call.

An easier and equally performant alternative would be - Define an external table instead of the sqlloader, and define an oracle job to load from this external table.
0

Featured Post

The new generation of project management tools

With monday.com’s project management tool, you can see what everyone on your team is working in a single glance. Its intuitive dashboards are customizable, so you can create systems that work for you.

  • 2
  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now