Results 1 to 8 of 8
  1. #1
    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!

  2. #2
    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.

  3. #3
    Join Date
    Oct 2003
    Posts
    4

    Re: Export Error After Change Character Set

    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.

  4. #4
    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.

  5. #5
    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.

  6. #6
    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.

  7. #7
    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?

  8. #8
    Join Date
    Oct 2003
    Posts
    4
    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.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •