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

Oops. For clarity, I should also have mentioned changing the appropriate NLS parameter values in the init.ora file before recreating the database.

Graham

kcclimited wrote:

> 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