how can i apply DDL scripts to the distributed databases?

[beksalur]

hi,
i want to apply the DDL statements in a script file to the schemas in distributed databases. i have 16 database and each of them have 4-5 schemas ,total of 110 schema needs to be in syncronous with a master schema.

how can i apply the changes(a script file which contains DML statements from that master schema) in that master schema at the same time to the other schemas.

is Change Manager suitable for it?
Regards.

 

[LKBrwnDBA]

Use the OEM Change Management Pack.



----------------------------------------------------------------------------
The person who says it can't be done should not interrupt the person doing it. -- Chinese proverb