Register today for Oracle CloudWorld. October 17th - 20th, Las Vegas

Register now

Hillel Cooperman, Senior VP of User Experience Design, has a message for you on Oracle CloudWorld

Watch now
ADB Object Deployments - Hub and Spoke configuration — Cloud Customer Connect
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

Question
4
Views
0
Comments
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?

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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