Originally posted by mommydba
Did you check to see if there were any invalid objects after reimporting the user? The error is based on a compilation of an object, not in the character set itself. It may be that there is a character defined within the object (package, procedure, etc....) that is not defined in the new character set.
Thanks for your reply. Today, my PC remotely logs in to the network with Oracle 126.96.36.199.1 client using character set ZHT16MSWIN950 and start export(utility EXP). But it completed successfully. It brings me to alert whether it relates to the imcompatible character set. First time, the problem occured with the Oracle server machine. Before displaying the process of export. It has the following message:
Export done in WE8MSWIN1252 character set and AL16UTF16 NCHAR character set
server uses ZHT16MSWIN950 character set <possible charset conversion>
I am curious why it states WE8MSWIN1252 character set which I have defined this character set before and where did Oracle get that character set. Maybe this will be the reason I get those errors.