When you right-click an object and select Create, Alter, or Drop from the context-sensitive menu, you are prompted to select which editor to use. The Data Object Editor is designed to change one object at a time. The Change Management Script Editor, which is included with Optim Database Administrator, extends the basic functionality that the Data Object Editor contains. The Data Object Editor is best suited to making simple changes or changes to a development environment.
The Change Management Script Editor is designed to manage multiple changes in a single change management script, view the objects that will impacted by the changes, allow you to specify unload and reload options for preserving data when an extended alter requires that an object be dropped and re-created, view a report that summarizes the changes that will be made before you run the commands, and let you quickly undo any changes.