EDIT DATABASE (Rename)

The EDIT DATABASE (Rename) command changes the name used by the broker to refer to the specified database.

Format

EDIT DATABASE <db_unique_name> RENAME TO <new_db_unique_name>;

Command Parameters

db_unique_name

The current value of the DB_UNIQUE_NAME initialization parameter.

new_db_unique_name

The new value of the DB_UNIQUE_NAME initialization parameter.

Usage Notes

• Use this command to track changes to the DB_UNIQUE_NAME initialization parameter for this database.

  Caution:

  The db_unique_name must always match the value for that database's DB_UNIQUE_NAME initialization parameter.

• This command can only be done when broker management of the database that you are renaming is disabled.

Command Example

The following example shows how to edit and rename a database.

DGMGRL> DISABLE DATABASE 'South_Sales_typo';
Disabled.

DGMGRL> EDIT DATABASE 'South_Sales_typo' RENAME TO 'South_Sales';
Succeeded.

DGMGRL> ENABLE DATABASE 'South_Sales';
Enabled.