Home » RDBMS Server » Server Utilities » Exporting data error in oracle 9i
Exporting data error in oracle 9i [message #267242] Wed, 12 September 2007 16:14 Go to next message
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 - Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release - 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

[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 Go to previous message
Frank Naude
Messages: 4509
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
Previous Topic: Error EXP-00091: Exporting questionable statistics. about character set
Next Topic: import fails
Goto Forum:

Current Time: Fri Jul 21 00:03:13 CDT 2017

Total time taken to generate the page: 0.08400 seconds