Home | Previous Page | Next Page   Data Migration Utilities > The dbexport and dbimport Utilities >

Database Locale Changes

You can use dbimport 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.
Home | [ Top of Page | Previous Page | Next Page | Contents | Index ]