Object management features

You can initiate changes to database objects (CREATE, ALTER, and DROP) directly from the Administration Explorer or the Object List.

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.

Important: To use the change management function in Optim™ Database Administrator, which includes the ability to use change managements scripts and the Change Management Script Editor, the Database Change Management feature of Optim Database Administrator must be installed and change management capability must be enabled. For more information, see Enabling change management capability.

Feedback