changing nls_characters set from US7ASCII to WE8ISO8859P1 in Oracle 8.0.5

From: Shannon St. Dennis <sstdenni_at_cityregina.com>
Date: 2000/05/24
Message-ID: <392c390b$1@news3.cableregina.com>#1/1

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 Wed May 24 2000 - 00:00:00 CDT