The name of a database cannot be edited in BDB Administration Tools once it has been created. If you wish to rename a database, it must be renamed manually in your directory and then also in the RDBMS.
In order to rename a database, it first must be stopped and unregistered from the Node Manager. Before doing this, ensure that there are no users connected to the database.
1. Connect to the Node Manager in the BDB Administration Tools.
2. Double-click the Database Properties icon in the Tools panel.
The Available Databases and their Properties are listed in the main window.
3. Select the database that you wish to rename.
4. Select the Stop command.
Menu | Database > Stop |
Pop-up | Stop (database name) |
It may take a few minutes to stop the database. When it is finished, the label will change to "Stopped". It can now be unregistered.
5. Select the Unregister command.
Menu | Database > Unregister |
Pop-up | Available Databases > selected database > Unregister |
The database will be removed from the list of Available Databases. The next step is to rename the actual database folder.
6. In Windows Explorer, navigate to the node location containing the database to be renamed.
7. Right-click the database parent folder and select Rename.
8. Enter a new name for the database folder.
9. Return to BDB Administration Tools and re-register the database. See Register a Database for instructions.
The database is added back to the list of Available Databases, but with the new name and still stopped. The bathynodemanagerconfig.xml file will automatically be updated with the new name. Before you can start the database, it must also be renamed in the RDBMS. Please refer to the following resources for information on renaming a database in the RDBMS:
• pgAdmin documentation on the Windows Start menu
• http://www.oracle.com/pls/db112/homepage
Further details on administration tasks in the RDBMS are also available upon request from CARIS Customer Service. |