Renaming two database names that have etx indexes
You cannot rename two databases with etx indexes to the other names of a database even if you drop the indexes, unless you follow a procedure that includes restarting the server. Each database maintains in-memory cached data that includes the database name.
Before you begin
About this task
Given two databases my_db_1 and my_db_2:
Procedure
- Drop all etx indexes on my_db_1.
- Close my_db_1.
- Drop all etx indexes on my_db_2.
- Close my_db_2.
- Rename my_db_1 database to temp_etx.
- Rename my_db_2 to my_db_1.
- Rename temp_etx to my_db_2.
- Stop and restart the server with the oninit utility.