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

You must have DBA privilege on the database.

About this task

Given two databases my_db_1 and my_db_2:

Procedure

  1. Drop all etx indexes on my_db_1.
  2. Close my_db_1.
  3. Drop all etx indexes on my_db_2.
  4. Close my_db_2.
  5. Rename my_db_1 database to temp_etx.
  6. Rename my_db_2 to my_db_1.
  7. Rename temp_etx to my_db_2.
  8. Stop and restart the server with the oninit utility.