OraFAQ Forum: Unix » Calling sqloader within Korn shell scripts

Home » Infrastructure » Unix » Calling sqloader within Korn shell scripts

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Calling sqloader within Korn shell scripts [message #149604]

Fri, 02 December 2005 07:59

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

Report message to a moderator

Re: Calling sqloader within Korn shell scripts [message #149609 is a reply to message #149604]

Fri, 02 December 2005 08:08

Mahesh Rajendran
Messages: 10708
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.

Report message to a moderator

Re: Calling sqloader within Korn shell scripts [message #149615 is a reply to message #149609]

Fri, 02 December 2005 08:23

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.

Report message to a moderator

Re: Calling sqloader within Korn shell scripts [message #149620 is a reply to message #149615]

Fri, 02 December 2005 08:34

Mahesh Rajendran
Messages: 10708
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

Report message to a moderator

Previous Topic:	script issue for cronjob
Next Topic:	runInstaller hangs

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Nov 29 01:17:13 CST 2024