Solved

sql loader call

Posted on 2007-03-29
6
714 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
Comment Utility
maybe this faq will help:
http://orafaq.com/faqloadr.htm
0
 
LVL 3

Expert Comment

by:popa_duhu
Comment Utility
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
Comment Utility
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
Comment Utility
I am looking for creating a batch job that executes a Sql loader process?

Is it Possible..any examples
0
 

Author Comment

by:suhinrasheed
Comment Utility
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
Comment Utility
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

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.

Join & Write a Comment

Suggested Solutions

Working with Network Access Control Lists in Oracle 11g (part 2) Part 1: http://www.e-e.com/A_8429.html Previously, I introduced the basics of network ACL's including how to create, delete and modify entries to allow and deny access.  For many…
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, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.
Via a live example, show how to restore a database from backup after a simulated disk failure using RMAN.

771 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

14 Experts available now in Live!

Get 1:1 Help Now