One DDL SQL script that has kept at certain location should be run on multiple servers to keep database synchronize. This task has to do in oracle database and this should be done as a job from scheduler. How will you do it?

Questions by Passion

Showing Answers 1 - 3 of 3 Answers

senthilora

  • Sep 24th, 2007
 

There are many ways to do that.  Following is the one of the ways I would prefer as I do it usually.

You can achieve this by having a small Unix Scripting / Windows Shell Scripting / any other scripting (including PR*C).

This Unix/WSH/ script has to go through a loop for each database and get connect and execute the SQL script.

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions