Re: changing nls_characters set from US7ASCII to WE8ISO8859P1 in Oracle 8.0.5

Sorry, but exporting, recreating the database and importing is the only way that I know of getting round this problem. US7ASCII is the default 'character set' at database creation; to change this add the line CHARACTER SET WE8ISO8859PI to the CREATE DATABASE command. Since I was caught out by this a few years ago I make a point of including this line in every database that I have since created.

Graham

"Shannon St. Dennis" wrote:

> We have an application that currently lives in an 8.0.5 database (on AIX).
>
> The vendor has asked that we change the characterset from US7ASCII to
> WE8ISO8859P1.
>
> Currently:
> NLS_LANGUAGE=AMERICAN
> NLS_TERRITORY=AMERICA
> NLS_CHARACTERSET=US7ASCII
> NLS_NCHAR_CHARACTERSET=US7ASCII
>
> I have read that I need to backup (export) my database, then delete and
> recreate it with the appropriate nls settings. Then I just reimport the
> data.
>
> Is this the best way on an 8.0.x database? Is this the only way? I saw some
> metalink notes that indicated you have to do it this way in 8.0.x
>
> The real problem is the time it will take to export/recreate/import the
> data.
>
> Any ideas? And how do I change the nls_characterset on a database create?
>
> Thanks
> Shannon St. Dennis
>
> sstdenni_at_cityregina.com
Received on Thu May 25 2000 - 00:00:00 CDT