CodeSnip: How to Run Any Oracle Script File Through Shell Script in UNIX
page 5 of 5
by Deepankar Sarangi
Feedback
Average Rating: This article has not yet been rated.
Views (Total / Last 10 Days): 3383/ 178

Conclusion

By following the method mentioned above, one can make any oracle script file run from oracle through shell script. The shell programming mentioned above is a simple one, but it can be extended to handle complicated business requirements. Also, any oracle process that needs to be run frequently can be invoked through a shell script, which in turn can be configured to run at given time intervals. If the server is a remote one then there may be a possibility that the running oracle process may get interrupted for say network issues. To avoid the issue, the shell script may be run in nohup mode allowing the process to run in the background from server side until the end without getting affected for different network issues.


View Entire Article

Article Feedback

Title:  
Name:  
Url: ( Optional )
Comment:  
Please add 1 and 3 and type the answer here:

User Comments

No comments posted yet.

Product Spotlight
Product Spotlight 
Learn More
.NET Tools
asp.net shopping cart
asp.net chart control






Ads Powered by Lake Quincy Media
Community Advice: ASP | SQL | XML | Regular Expressions | Windows


©Copyright 1998-2008 ASPAlliance.com  |  Page Processed at 7/5/2008 9:15:11 PM  AspAlliance Recent Articles RSS Feed
About ASPAlliance | Newsgroups | Advertise | Authors | Email Lists | Feedback | Link To Us | Privacy | Search