OraFAQ Forum: Unix » Unix shell scripting

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

Show: Today's Messages :: Show 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: 54250
Registered: March 2007
Location: Nanterre, France, http://...

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: 10572
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: Sun May 26 00:38:42 CDT 2013

Total time taken to generate the page: 0.11846 seconds