Thank you for supporting the Cloud Customer Connect Community in 2024. It's a gift to work with you!

Look back
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

ADB Object Deployments - Hub and Spoke configuration

edited Nov 2, 2020 12:51PM in Autonomous Database

Summary

ATP database (hub) control one or more 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 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?

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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