3 Replies Latest reply: Jan 15, 2013 11:21 PM by 984856 RSS

    EXP-00008: ORACLE error 6552 encountered

    984856
      Hi
      i am facing with "EXP-00008: ORACLE error 6552 encountered" error
      please help me

      Configuration read
      [Tue Jan 15 09:54:50 IST 2013] [INFO] Directory is present

      Export: Release 10.2.0.1.0 - Production on Tue Jan 15 09:55:07 2013

      Copyright (c) 1982, 2005, Oracle. All rights reserved.


      Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - 64bit Production
      With the Partitioning, OLAP and Data Mining options
      Export done in US7ASCII character set and AL32UTF8 NCHAR character set
      server uses AL32UTF8 character set (possible charset conversion)

      About to export specified tables via Conventional Path ...
      . . exporting table SBRSAI2GCOVER
      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 SBRSAI3GCOVER
      EXP-00008: ORACLE error 1003 encountered
      ORA-01003: no statement parsed
      . . exporting table SBRSAIFAPIDOVERRIDE
      EXP-00008: ORACLE error 1003 encountered
      ORA-01003: no statement parsed
      . . exporting table SBRSAIFAPIDSAI
      EXP-00008: ORACLE error 1003 encountered
      ORA-01003: no statement parsed
      . . exporting table SBRBLMFAPLCDEXCLUSIONLIST
      EXP-00008: ORACLE error 1003 encountered
      ORA-01003: no statement parsed
      . . exporting table SBRSAIDEFAULT
      EXP-00008: ORACLE error 1003 encountered
      ORA-01003: no statement parsed
      . . exporting table SBRBLMFAPIDADSLPORTLOCATION
      EXP-00008: ORACLE error 1003 encountered
      ORA-01003: no statement parsed
      . . exporting table SBRUEREGISTER
      EXP-00008: ORACLE error 1003 encountered
      ORA-01003: no statement parsed
      . . exporting table SBRBLMSTATS
      EXP-00008: ORACLE error 1003 encountered
      ORA-01003: no statement parsed
      . . exporting table SBRBLMTRAPS
      EXP-00008: ORACLE error 1003 encountered
      ORA-01003: no statement parsed
      . . exporting table SBRFEMTOAP
      EXP-00008: ORACLE error 1003 encountered
      ORA-01003: no statement parsed
      . . exporting table SBRSAICOVERAGEHISTORY
      EXP-00008: ORACLE error 1003 encountered
      ORA-01003: no statement parsed
      . . exporting table BLMUSERS
      EXP-00008: ORACLE error 1003 encountered
      ORA-01003: no statement parsed
      . . exporting table BLM_CONFIGURATIONS
      EXP-00008: ORACLE error 1003 encountered
      ORA-01003: no statement parsed
      Export terminated successfully with warnings.
        • 1. Re: EXP-00008: ORACLE error 6552 encountered
          yoonas
          Hi,

          Please see

          PLS-553 when calling or compiling pl/sql objects [ID 286964.1]
          Export Fails With Errors EXP-8 ORA-6552 ORA-6553 [ID 822238.1]
          Master Note for Export and Import [ID 1264691.1]

          Regards
          Yoonas
          • 2. Re: EXP-00008: ORACLE error 6552 encountered
            Srini Chavali-Oracle
            >
            ...
            Export done in US7ASCII character set and AL32UTF8 NCHAR character set
            server uses AL32UTF8 character set (possible charset conversion)
            ...
            >

            You also need to set NLS_LANG variable appropriately before executing the export.

            http://www.oracle.com/technetwork/database/globalization/nls-lang-099431.html

            HTH
            Srini
            • 3. Re: EXP-00008: ORACLE error 6552 encountered
              984856
              Thanks for your quick response.
              could you please define, which parameter i need to change. and i have also tried with NLS_CHARACTERSET AL32UTF8


              PARAMETER VALUE
              ------------------------------ ----------------------------------------
              NLS_CSMIG_SCHEMA_VERSION 5
              NLS_LANGUAGE AMERICAN
              NLS_TERRITORY AMERICA
              NLS_CURRENCY $
              NLS_ISO_CURRENCY AMERICA
              NLS_NUMERIC_CHARACTERS .,
              NLS_CHARACTERSET US7ASCII
              NLS_CALENDAR GREGORIAN
              NLS_DATE_FORMAT DD-MON-RR
              NLS_DATE_LANGUAGE AMERICAN
              NLS_SORT BINARY

              PARAMETER VALUE
              ------------------------------ ----------------------------------------
              NLS_TIME_FORMAT HH.MI.SSXFF AM
              NLS_TIMESTAMP_FORMAT DD-MON-RR HH.MI.SSXFF AM
              NLS_TIME_TZ_FORMAT HH.MI.SSXFF AM TZR
              NLS_TIMESTAMP_TZ_FORMAT DD-MON-RR HH.MI.SSXFF AM TZR
              NLS_DUAL_CURRENCY $
              NLS_COMP BINARY
              NLS_LENGTH_SEMANTICS BYTE
              NLS_NCHAR_CONV_EXCP FALSE
              NLS_NCHAR_CHARACTERSET US7ASCII
              NLS_RDBMS_VERSION 10.2.0.1.0

              Thanks