O'Reilly logo

Oracle Enterprise Manager Cloud Control 12c: Managing Data Center Chaos by Porus Homi Havewala

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Schema Change Plan

Now that we know the differences between the two databases, the next step is to create a schema Change Plan. This is a new feature in Enterprise Manager Cloud Control 12c.

Using change plans, the developers can group together some or all of their database object changes, and package them for the DBA. Change plans can be created from comparisons that have found differences. They can also be created from ad hoc changes, or from development tools such as Oracle SQL Developer.

In a normal workflow process, the developer creates a Change Plan and submits it to the DBA, who is then able to review the Change Plan and apply it if the changes are acceptable. This can be done to multiple targets such as the test database, staging database, ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required