Re: Best way to recreate database for a character set change

From: Sybrand Bakker <sybrandb_at_hccnet.nl>
Date: Tue, 12 Oct 2004 11:34:00 +0200
Message-ID: <v69nm0hepn442t111604ildgapuavc4anj@4ax.com>

On 11 Oct 2004 22:47:05 -0700, jkaashoek_at_yahoo.com (Joop Kaashoek) wrote:

>We need to change our default character set to UTF8 and this can not
>be done with a simple alter command since our current character set is
>WE8MSWIN1252. So we need to recreate the database. What is the best
>way to do this? We want to keep the same instance name etc.
>
>Regards,
>Joop Kaashoek

export
create the database with new characterset import
make sure NLS_LANG is set correctly (to the old characterset) when importing.

--
Sybrand Bakker, Senior Oracle DBA

Received on Tue Oct 12 2004 - 04:34:00 CDT