OraFAQ Forum: Unix » Unix shell scripting

Home » Infrastructure » Unix » Unix shell scripting (Unix , Sun OS)

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

Unix shell scripting [message #488352]

Thu, 06 January 2011 10:28

chauhan_27
Messages: 2
Registered: January 2011
Location: Delhi

Junior Member

HI friends,
Am not very much good in unix but I need to develop a shell script that will first check whether a text file exist in a particular directory or not and if yes then it has to read content and then through sqlldr , it has to load the values into oracle table and once completed text file is to be moved to another directory. Need support urgently .

Report message to a moderator

Re: Unix shell scripting [message #488353 is a reply to message #488352]

Thu, 06 January 2011 10:36

Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Quote:

Need support urgently .

Post what you already did.

Regards
Michel

Report message to a moderator

Re: Unix shell scripting [message #488354 is a reply to message #488352]

Thu, 06 January 2011 10:37

Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

http://www.orafaq.com/forum/t/27068/2/
Talks about most of the stuff you asked for.
Just move the file to another directory.
Depending on your need, you can simply the script by just passing the input file directly to the sqlldr command line.
Make the script any fancier you want.

[Updated on: Thu, 06 January 2011 10:38]

Report message to a moderator

Re: Unix shell scripting [message #488610 is a reply to message #488354]

Mon, 10 January 2011 04:06

chauhan_27
Messages: 2
Registered: January 2011
Location: Delhi

Junior Member

Thanks a lot!!!

Report message to a moderator

Previous Topic:	Help!Oracle 8.1.7 Installation- Make Error on Solaris 8
Next Topic:	SQL*LOADER

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Nov 21 11:40:04 CST 2024