Solved

sql loader call

Posted on 2007-03-29
6
720 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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
levels for reporting 5 65
how to reset the password in Oracle 11g Express Edition 4 100
ORA-12560: TNS:protocol adapter error 8 83
Best RAID for a BDD Oracle 4 61
Why doesn't the Oracle optimizer use my index? Querying too much data Most Oracle developers know that an index is useful when you can use it to restrict your result set to a small number of the total rows in a table. So, the obvious side…
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 explains at a high level about the four available data types in Oracle and how dates can be manipulated by the user to get data into and out of the database.
This video explains what a user managed backup is and shows how to take one, providing a couple of simple example scripts.

911 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

19 Experts available now in Live!

Get 1:1 Help Now