Changing the database locale with dbimport

You can use the dbimport utility to change the locale of a database.

Procedure

To change the locale of a database:

  1. Set the DB_LOCALE environment variable to the name of the current database locale.
  2. Run dbexport on the database.
  3. Use the DROP DATABASE statement to drop the database that has the current locale name.
  4. Set the DB_LOCALE environment variable to the desired database locale for the database.
  5. Run dbimport to create a new database with the desired locale and import the data into this database.