Export Error After Change Character Set

IvanKK · #1 (**permalink**) 10-28-03, 02:02

In Oracle 9.02 environment, after performing alter character set in database process(Export entire database, drop user A, alter character set[ZHT16BIG5 to ZHT16MSWIN950] , restart Oracle, create user A, import all information of user A), export using EXP command with following errors:
. exporting tablespaces definitions
...
.exporting PUBLIC type synonyms
EXP-00008: ORACLE error 6552 encountered
ORA-06552: PL/SQL: Compilation unit analysis termintated
ORA-06553: PLS-553: character set name is not recognised
EXP-00000: Export terminated unsuccessfully

Pls reply with the cause with solution as well. Thanks!

mommydba · #2 (**permalink**) 10-28-03, 14:16

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.

IvanKK · #3 (**permalink**) 10-28-03, 23:51

Quote:

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 9.0.1.0.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.

text1978 · #4 (**permalink**) 11-16-03, 22:58

I meet this error too.

Code:

Export done in US7ASCII character set and AL16UTF16 NCHAR character set
server uses UTF8 character set (possible charset conversion)

About to export the entire database ...
. exporting tablespace definitions
. exporting profiles
. exporting user definitions
. exporting roles
. exporting resource costs
. exporting rollback segment definitions
. exporting database links
. exporting sequence numbers
. exporting directory aliases
. exporting context namespaces
. exporting foreign function library names
. exporting PUBLIC type synonyms
EXP-00008: ORACLE error 6552 encountered
ORA-06552: PL/SQL: Compilation unit analysis terminated
ORA-06553: PLS-553: character set name is not recognized
EXP-00000: Export terminated unsuccessfully

I check NLS parameters in the client and server environment using $env|grep NLS and find they are in same.

IvanKK · #5 (**permalink**) 11-16-03, 23:32

I still investigate the problem. But I found that it does not have problem if using 9.01 Oracle client to do the exporting. But I don't know why there is difference behavior between 9.01 and 9.2 Oracle client version. Since I need to perform the export in 9.2, if you solve the problem, pls let me know. For your case, you can try using different version, maybe it works.

text1978 · #6 (**permalink**) 11-17-03, 01:20

Someone said that I must adjust the NLS_LANG parameters on the clinet. After change it and also I can run the .bash_profile correctly. But when use export again I meet the error below:

Code:

$ exp \'sys/text@Test.World as sysdba\'

Export: Release 9.2.0.1.0 - Production on Mon Nov 17 13:25:58 2003

Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.


EXP-00056: ORACLE error 12705 encountered
ORA-12705: invalid or unknown NLS parameter value specified

Both my client and server platform are rehhat9.0 and the same rdbms edition(oracle9.2.0forlinux) to be installed on.

text1978 · #7 (**permalink**) 11-17-03, 03:14

Hi, IvanKK How did you modify your rdbms,s character set?
I issue $export NLS_LANG-American_America.UTF8. But it seem not bo be effective. and why asd how?

IvanKK · #8 (**permalink**) 11-17-03, 03:40

Quote:

Originally posted by text1978
Hi, IvanKK How did you modify your rdbms,s character set?
I issue $export NLS_LANG-American_America.UTF8. But it seem not bo be effective. and why asd how?

Since I am busy with other stuff, I don't have time to investigate for that problem right now.

Internet Services

Web Development

Digital Marketing

Consumer Tech