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, ...
Get Oracle Enterprise Manager Cloud Control 12c: Managing Data Center Chaos now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
