Home » RDBMS Server » Server Administration » help!i am using exp and get error"EXP-00008: ORACLE error 6552 encountered"
help!i am using exp and get error"EXP-00008: ORACLE error 6552 encountered" [message #58772] Tue, 30 September 2003 00:16 Go to next message
Michael
Messages: 61
Registered: October 1999
Member
> Hi,
>
> hello!
> platform:Sun solaris 9
> oracle version:Enterprise Edition 9.2.0
>
> i am exporting db and getting error:
>
> $ exp zhyy/zhyy@gxyztest
>
> Export: Release 9.2.0.1.0 - Production on Tue Sep 30 11:13:20 2003
>
> Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
>
>
> Connected to: Oracle9i Enterprise Edition Release 9.2.0.1.0 - 64bit
Production
> With the Partitioning, OLAP and Oracle Data Mining options
> JServer Release 9.2.0.1.0 - Production
> Enter array fetch buffer size: 4096 >
>
> Export file: expdat.dmp >
>
> (1)E(ntire database), (2)U(sers), or (3)T(ables): (2)U > 1
>
> Export grants (yes/no): yes > yes
>
> Export table data (yes/no): yes > yes
>
> Compress extents (yes/no): yes > yes
>
> Export done in ZHS16CGB231280 character set and AL16UTF16 NCHAR
character set
>
> 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
> $ exp zhyy/zhyy@gxyztest owner=zhyy
>
> Export: Release 9.2.0.1.0 - Production on Tue Sep 30 11:13:54 2003
>
> Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
>
>
> Connected to: Oracle9i Enterprise Edition Release 9.2.0.1.0 - 64bit
Production
> With the Partitioning, OLAP and Oracle Data Mining options
> JServer Release 9.2.0.1.0 - Production
> Export done in ZHS16CGB231280 character set and AL16UTF16 NCHAR
character set
>
> About to export specified users ...
> . exporting pre-schema procedural objects and actions
> . exporting foreign function library names for user ZHYY
> . 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
>
> help me!
> thanks any hints!
>
>
> Best regards.
> michael
Re: help!i am using exp and get error"EXP-00008: ORACLE error 6552 encountered" [message #58780 is a reply to message #58772] Tue, 30 September 2003 06:01 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
check you NLS parameters in the client and server environment and make sure they are same.
Re: help!i am using exp and get error"EXP-00008: ORACLE error 6552 encountered" [message #61623 is a reply to message #58772] Tue, 11 May 2004 17:45 Go to previous message
sophia
Messages: 2
Registered: May 2004
Junior Member
I encounter the same problem,I've checked the NLS in the client and the server,they are the same.

But the catlog.sql and catproc.sql can't be excuted properly.What's wrong and what can I do!
Previous Topic: Cannot start oracle
Next Topic: Help Urgent
Goto Forum:
  


Current Time: Wed Jan 08 13:51:02 CST 2025