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

In article <392c390b$1_at_news3.cableregina.com>,   "Shannon St. Dennis" <sstdenni_at_cityregina.com> 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?
>

Connect as sys.

update props$
set value$='WE8ISO8859P1'
where name in ('NLS_CHARACTERSET', 'NLS_NCHAR_CHARACTERSET');

Be careful! If you set it to wrong (non-existing) characterset, database won't start after shutdown! Do a cold backup before this change.

Alex Filonov.

> Thanks
> Shannon St. Dennis
>
> sstdenni_at_cityregina.com
>
>

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Fri May 26 2000 - 00:00:00 CDT