If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

 
Go Back  dBforums > Database Server Software > Oracle > Export Error After Change Character Set

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old
Registered User
 
Join Date: Oct 2003
Posts: 4
Post Export Error After Change Character Set

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!
Reply With Quote
  #2 (permalink)  
Old
Registered User
 
Join Date: Oct 2003
Posts: 3
Re: Export Error After Change Character Set

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.
Reply With Quote
  #3 (permalink)  
Old
Registered User
 
Join Date: Oct 2003
Posts: 4
Re: Export Error After Change Character Set

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.
Reply With Quote
  #4 (permalink)  
Old
Registered User
 
Join Date: Sep 2003
Posts: 14
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.
Reply With Quote
  #5 (permalink)  
Old
Registered User
 
Join Date: Oct 2003
Posts: 4
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.
Reply With Quote
  #6 (permalink)  
Old
Registered User
 
Join Date: Sep 2003
Posts: 14
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.
Reply With Quote
  #7 (permalink)  
Old
Registered User
 
Join Date: Sep 2003
Posts: 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?
Reply With Quote
  #8 (permalink)  
Old
Registered User
 
Join Date: Oct 2003
Posts: 4
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.
Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On