Re: NLS_CHARACTERSET

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Fri, 1 Jun 2001 17:40:19 +0200
Message-ID: <thfdn14m1shud6@beta-news.demon.nl>

"Robert Boyle" <rboyle_at_cyantel.com> wrote in message news:8729a6fe.0106010654.752fc078_at_posting.google.com...
> Hi there,
>
> How do you change the database NLS_CHARACTERSET? I thought it would
> have been in the .ora file but it's not.
>
> Cheers
> Robert

Answer to this is version dependent, and please always include it in your posts.
In Oracle 7 and 8.0 it is not possible without recreating the database. In Oracle 8i you can issue an alter database set characterset (check the sql reference manual for exact syntax) as long as the new characterset is an exact super- or subset of the old characterset. Otherwise you'll still need to recreate the database.

Hth,

Sybrand Bakker, Oracle DBA Received on Fri Jun 01 2001 - 10:40:19 CDT