Home » Infrastructure » Unix » Calling sqloader within Korn shell scripts
Calling sqloader within Korn shell scripts [message #149604] Fri, 02 December 2005 07:59 Go to next message
ashwin.bhat
Messages: 2
Registered: December 2005
Location: Bangalore
Junior Member

Tech Gurus ,

I want to call sqloader scripts within Korn shell program on unix.I am very new to unix scripting .

How can i do this .I can succesfully load .csv file into oracle 9i.I want to call this within unix shell script and i want to schedule this script using $universe tool.
Can any one unicast me regarding this.

Any docs ,Personel ideas ,mails would really help me .

I am new member in this group,

Thanks in advance,
Ashwin
Re: Calling sqloader within Korn shell scripts [message #149609 is a reply to message #149604] Fri, 02 December 2005 08:08 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
I dont know about this
>>using $universe too
For sqlldr scripts search the forum and post the specific question.

Re: Calling sqloader within Korn shell scripts [message #149615 is a reply to message #149609] Fri, 02 December 2005 08:23 Go to previous messageGo to next message
ashwin.bhat
Messages: 2
Registered: December 2005
Location: Bangalore
Junior Member

I am comfortable writing and executing SQLOADER.

I would like to incorporate the sqloader process within korn shell script and execute the sqloader process using korn shell script.Insight to writing script for calling sqloader will really help me.
Re: Calling sqloader within Korn shell scripts [message #149620 is a reply to message #149615] Fri, 02 December 2005 08:34 Go to previous message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
Did you read the previous response.
Same response again.
search the forum and post the specific question / issues with OS/oracle versions/logfiles/ddl/your script , what you exactly want ... any information that would help here.

For sqlldr know how,
http://www.orafaq.com/faq/sql_loader
and
http://download-west.oracle.com/docs/cd/B10501_01/server.920/a96652/toc.htm
For unix related thingies
http://www.orafaq.com/faq/operating_systems
http://www.orafaq.com/scripts/index.htm#UNIX
and
www.google.com

All you need is something like this.
name the script something.
Set execute permssions.
execute it.

#!/bin/bash
export ORACLE_HOME=yourhome
export PATH=$ORACLE_HOME/bin:$PATH
sqlldr userid=scott/tiger control=dept.ctl
Previous Topic: script issue for cronjob
Next Topic: runInstaller hangs
Goto Forum:
  


Current Time: Thu Mar 28 04:07:37 CDT 2024