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?

Passion
Profile Answers by Passion Questions by Passion
Jul 13th, 2007
1
2361

Showing Answers 1 - 1 of 1 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.