OraFAQ Forum: Server Utilities » Exporting data error in oracle 9i

Home » RDBMS Server » Server Utilities » Exporting data error in oracle 9i

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Exporting data error in oracle 9i [message #267242]

Wed, 12 September 2007 16:14

ashutosh_1116
Messages: 5
Registered: November 2006
Location: India

Junior Member

Hi Dear,
when i m trying to take backup of our data it gives following error's through EXP command

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 WE8MSWIN1252 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

help me out
Thanks,
Ashutosh

[Updated on: Thu, 13 September 2007 13:26] by Moderator

Report message to a moderator

Re: Exporting data error in oracle 9i [message #268092 is a reply to message #267242]

Mon, 17 September 2007 08:59

Frank Naude
Messages: 4587
Registered: April 1998

Senior Member

Try to set the NLS_LANG environment variable before running the export.

For good values to try, select * from nls_database_parameters;

For more info, see http://www.oracle.com/technology/tech/globalization/htdocs/nls_lang%20faq.htm

Report message to a moderator

Previous Topic:	Error EXP-00091: Exporting questionable statistics. about character set
Next Topic:	import fails

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Dec 25 10:10:44 CST 2024