Home » Infrastructure » Unix » Unix shell scripting (Unix , Sun OS)
Unix shell scripting [message #488352] Thu, 06 January 2011 10:28 Go to next message
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 .
Re: Unix shell scripting [message #488353 is a reply to message #488352] Thu, 06 January 2011 10:36 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
Need support urgently .

Post what you already did.

Regards
Michel
Re: Unix shell scripting [message #488354 is a reply to message #488352] Thu, 06 January 2011 10:37 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10707
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 Go to previous message
chauhan_27
Messages: 2
Registered: January 2011
Location: Delhi
Junior Member
Thanks a lot!!!
Previous Topic: Help!Oracle 8.1.7 Installation- Make Error on Solaris 8
Next Topic: SQL*LOADER
Goto Forum:
  


Current Time: Fri Mar 29 01:33:23 CDT 2024