Home » RDBMS Server » Server Utilities » EXP-00008: ORACLE error 6552 encountered (Solaris10 with Oracle 10g)
EXP-00008: ORACLE error 6552 encountered [message #575203] Mon, 21 January 2013 05:02 Go to next message
deepak416
Messages: 56
Registered: January 2013
Location: Pune
Member
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.
Re: EXP-00008: ORACLE error 6552 encountered [message #575205 is a reply to message #575203] Mon, 21 January 2013 05:08 Go to previous messageGo to next message
Michel Cadot
Messages: 58590
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
1/ Verify you correctly transfer the dump file (in binary mode)
2/ AL32UTF8 is not a valid national character set in 10.2: from the documentation only AL16UTF16 and UTF8 are allowed.

What was the original database version?
What is your current NLS_LANG parameter?

Regards
Michel
Re: EXP-00008: ORACLE error 6552 encountered [message #575207 is a reply to message #575205] Mon, 21 January 2013 05:16 Go to previous messageGo to next message
deepak416
Messages: 56
Registered: January 2013
Location: Pune
Member
Thanks for your quick response....
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
Re: EXP-00008: ORACLE error 6552 encountered [message #575221 is a reply to message #575207] Mon, 21 January 2013 06:34 Go to previous message
Michel Cadot
Messages: 58590
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
i have also tried with NLS_CHARACTERSET AL32UTF8


What does this mean?

Where does your output comes from (original or target database) and is the output of which query?
Use SQL*Plus and copy and paste your session, the WHOLE session.

Before, Please read OraFAQ Forum Guide and How to use [code] tags and make your code easier to read.
Make sure that lines of code do not exceed 80 characters when you format.
Indent the code, use code tags and align the columns in result.
Use the "Preview Message" or "Preview Quick Reply" button to verify.

Also Answer my questions:

Quote:
What was the original database version?
What is your current NLS_LANG parameter?


Regards
Michel
Previous Topic: migrate ful db
Next Topic: Unable to import ( impdp )
Goto Forum:
  


Current Time: Sat Jul 26 15:03:10 CDT 2014

Total time taken to generate the page: 0.08180 seconds