Results 1 to 2 of 2
  1. #1
    Join Date
    Apr 2004
    Posts
    1

    Red face Unanswered: Exp errors after changing CHARACTER_SET

    Hi,

    Oracle 9i on linux RedHat 7.3

    After the installation of a new database, I have modify the NLS_CHARACTERSET and NLS_NCHAR_CHARACTERSET by this way :

    UPDATE SYS.PROPS$ SET VALUE$ = 'US7ASCII' WHERE NAME = 'NLS_CHARACTERSET';
    UPDATE SYS.PROPS$ SET VALUE$ = 'US7ASCII' WHERE NAME = 'NLS_NCHAR_CHARACTERSET';

    shutdown and restart.

    Now when I want to export some data :
    exp user/password file=exp.dmp tables=TOTO,TITI

    I have th following errors :

    Export: Release 9.2.0.1.0 - Production on Tue Apr 13 15:37:10 2004

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

    Connected to: Oracle9i Enterprise Edition Release 9.2.0.1.0 - Production
    With the Partitioning, OLAP and Oracle Data Mining options
    JServer Release 9.2.0.1.0 - Production
    Export done in US7ASCII character set and US7ASCII NCHAR character set

    About to export specified tables via Conventional Path ...
    . . exporting table TOTO
    EXP-00008: ORACLE error 6552 encountered
    ORA-06552: PL/SQL: Compilation unit analysis terminated
    ORA-06553: PLS-553: character set name is not recognized
    . . exporting table TITI
    EXP-00008: ORACLE error 6552 encountered
    ORA-06552: PL/SQL: Compilation unit analysis terminated
    ORA-06553: PLS-553: character set name is not recognized

    Export terminated successfully with warnings.


    Even if the export terminated successfully my tables are not exported. if I import the exp.dmp file in an index file, I got an empty file.

    Could anyone help me please ??

    Thanks

  2. #2
    Join Date
    Jan 2004
    Posts
    370
    You should never have updated props$
    Try to repair (reverse) the damage first, then sort out your NLS stuff.

Posting Permissions

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