-
I've altered both Database's character set them to:
NLS_CHARACTERSET WE8ISO8859P1
NLS_NCHAR_CHARACTERSET WE8ISO8859P1
Yet export defaults to US7ASCII, and ends in the following message:
Export done in US7ASCII character set and WE8ISO8859P1 NCHAR character set server uses WE8ISO8859P1 character set (possible charset conversion).
Problem comes when trying to import that file in my NT, which uses WE8ISO8859P1, I' getting an IMP-0069 error stating that it could not convert to environment character set's handle.
Is there a way to change export character set from USA7ASCII to WE8ISO8859P1, and or any other solution to the export/import problem described above.
TIA.
-
your database and your NLS environment variables need to be set to the same character set. check your NLS environment settings to ensure they're set to the WE character set.
-
The reason why you are getting that messate is because the character set of your database is different from the character set where you are running your export program. If you are in UNIX, it could be that the character set of the UNIX server is US7ASCII, that is why when you do an export oracle has to convert it to US7ASCII.
-
Done.
I just added the following line to oracle's .bash_profile:
export NLS_LANG=american.WE8ISO8859P1
Thanks.