You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

ATP Object Deployments - Hub and Spoke configuration

Received Response
5
Views
2
Comments
edited Apr 16, 2022 7:54AM in Autonomous Database 2 comments

Summary

Looking to have an ATP database (hub) control one or more other ATP or ADW databases (spokes) with regard to object deployments for things like views\MVs and procedures

Content

Hi All,

I was looking for some advice. I am looking to have an ATP database (hub) control one or more other ATP or ADW databases (spokes) with regard to object deployments for things like views\MVs and procedures. i.e. the hub holds the metadata to create the objects and pushes deployments to the spokes.

I was thinking I could create DB Links between the hub and spokes which allows me to push DDL scripts "CREATE OR REPLACE..." to the spoke where they will be executed locally as dynamic SQL. Does this sound feasible?

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!