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): 71050/ 113

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

User Comments

No comments posted yet.

Product Spotlight
Product Spotlight 





Community Advice: ASP | SQL | XML | Regular Expressions | Windows


©Copyright 1998-2021 ASPAlliance.com  |  Page Processed at 2021-11-26 6:00:40 PM  AspAlliance Recent Articles RSS Feed
About ASPAlliance | Newsgroups | Advertise | Authors | Email Lists | Feedback | Link To Us | Privacy | Search