Changing the database locale with dbimport

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

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.
Parent topic: The dbexport and dbimport utilities
Copyright© 2020 HCL Technologies Limited