character set not compatible
I have created a new database version 9.2 with characterset AL32UTF8 and national characterset AL16UTF8.
The old database which I try to import from is using characterset US7ASCII instead.
This will caused an error shown below when I try to connect to a function or procedure using a db link.
ORA-06550: line 1, column 29:
PLS-00553: character set name is not recognized
ORA-06550: line 0, column 0:
PL/SQL: Compilation unit analysis terminated
How do i solve this??
By the way, I have alter the database character set and national character set to UTF8 before the export form the old database 8.1.7 before the import into the new database 9.2.0. But it still doesn't work and even caused some records to be lost as the columns are too large...
Extracted from my export log:
Export file created by EXPORT:V08.01.07 via conventional path
import done in UTF8 character set and AL16UTF16 NCHAR character set
import server uses AL32UTF8 character set (possible charset conversion)
export server uses UTF8 NCHAR character set (possible ncharset conversion)
Any help please? Many thanks in adavance!
Last edited by mooks; 06-11-2004 at 05:47 AM.
Click Here to Expand Forum to Full Width