Re: changing nls_characters set - yes you can do it

Shannon

In certain limited circumstances you are able to change the character set of a database without recreating it.
Luckily, you seem to meet all of the criteria.

This facility is undocumented in Oracle 8.0.5 but it's still possible.

Look on MetaLink for Technical Note :66320.1 (V8: Changing the database or national character set).

I've tried it and it does work.

Regards

Mike Hately

Shannon St. Dennis <sstdenni_at_cityregina.com> wrote in message news:392c390b$1_at_news3.cableregina.com...
> 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