Solved

sql loader call

Posted on 2007-03-29
6
723 Views
Last Modified: 2008-02-01
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
Comment
Question by:suhinrasheed
  • 2
  • 2
  • 2
6 Comments
 
LVL 3

Expert Comment

by:popa_duhu
ID: 18814468
maybe this faq will help:
http://orafaq.com/faqloadr.htm
0
 
LVL 3

Expert Comment

by:popa_duhu
ID: 18814481
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
 
LVL 27

Expert Comment

by:sujith80
ID: 18814512
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
PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

 

Author Comment

by:suhinrasheed
ID: 18821810
I am looking for creating a batch job that executes a Sql loader process?

Is it Possible..any examples
0
 

Author Comment

by:suhinrasheed
ID: 18822031
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
 
LVL 27

Accepted Solution

by:
sujith80 earned 500 total points
ID: 18822156
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

Announcing the Most Valuable Experts of 2016

MVEs are more concerned with the satisfaction of those they help than with the considerable points they can earn. They are the types of people you feel privileged to call colleagues. Join us in honoring this amazing group of Experts.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
query in Oracle forms Builder 2 49
MULTIPLE DATE QUERY 15 76
how to trim oracle sql sentence in unix 17 51
Field name with special character (Ñ) in Oracle 11 45
How to Create User-Defined Aggregates in Oracle Before we begin creating these things, what are user-defined aggregates?  They are a feature introduced in Oracle 9i that allows a developer to create his or her own functions like "SUM", "AVG", and…
Cursors in Oracle: A cursor is used to process individual rows returned by database system for a query. In oracle every SQL statement executed by the oracle server has a private area. This area contains information about the SQL statement and the…
This video shows how to recover a database from a user managed backup
This video shows how to configure and send email from and Oracle database using both UTL_SMTP and UTL_MAIL, as well as comparing UTL_SMTP to a manual SMTP conversation with a mail server.

816 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

11 Experts available now in Live!

Get 1:1 Help Now