Problem with export after upgrade to 9i 1

[parisdba]

Hi,

I have just upgraded my test server to 9i from 8.1.6.0.0. Now while taking an export it is showing the following error.


Export done in WE8MSWIN1252 character set and AL16UTF16 NCHAR character set
server uses WE8ISO8859P1 character set (possible charset conversion)

About to export specified tables via Conventional Path ...
Table(T) or Partition(T) to be exported: (RETURN to quit) > itemmaster

. . exporting table ITEMMASTER 2399 rows exported
EXP-00091: Exporting questionable statistics.
EXP-00091: Exporting questionable statistics.
EXP-00091: Exporting questionable statistics.
EXP-00091: Exporting questionable statistics.
EXP-00091: Exporting questionable statistics.
EXP-00091: Exporting questionable statistics.
EXP-00091: Exporting questionable statistics.
EXP-00091: Exporting questionable statistics.
EXP-00091: Exporting questionable statistics.
Table(T) or Partition(T) to be exported: (RETURN to quit) >

Export terminated successfully with warnings.

It seems that there is a difference in characterset.

1) How do i find out the current ncharset.
...the parameter NLS_LANG show american

2)How do u change the national charcterset other than while creating database.


thanks

 

[karluk]

1) select * from v$nls_parameters
where parameter = 'NLS_CHARACTERSET';

2) I don't think it's possible to change the database's character set without recreating the database, unless the old characterset is a subset of the new. Fortunately for you, you appear to be in this situation. WE8ISO8859P1 and WE8MSWIN1252 appear in Metalink document 119164.1 (Changing Database Character Set - Valid Superset Definitions)

To change the characterset, use the following commands in restricted session. (And review Metalink document 66320.1 for details. I got this information from document 66320.1.)

ALTER DATABASE CHARACTER SET WE8MSWIN1252;
ALTER DATABASE NATIONAL CHARACTER SET AL16UTF16;

As always, when you are making fundamental changes to your database, make sure that you take a backup immediately before making the change.

 

[karluk]

Sorry, I misread your first question. The correct answer is

select * from v$nls_parameters
where parameter = 'NLS_NCHAR_CHARACTERSET';