Home » RDBMS Server » Server Utilities » expdp displays output in German (windows server 2008 R2 Oracle Database 11g Release 11.2.0.1.0 - 64bit Production)
expdp displays output in German [message #564599] Sun, 26 August 2012 08:29 Go to next message
Andrey_R
Messages: 188
Registered: January 2012
Location: Euro-Asia
Senior Member

I have a server configured to German & english.
when i connect with SQLPLUS, i have German language server output,
but when i do "alter session set nls_language='AMERICAN'" - it solves the issue for me.

I need the same for expdp command, but I don't know how to do this.
I have tried to add a parameter nls_language, but expdp doesn't recognize it.

Is it possible to somehow see server output of the expdp & writing it to the log file in english?

Thanks in advance,
Andrey
Re: expdp displays output in German [message #564605 is a reply to message #564599] Sun, 26 August 2012 08:57 Go to previous messageGo to next message
Michel Cadot
Messages: 58938
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Language has no importance to export.
Now if you SHOW us what you do and get maybe we can help you.

Regards
Michel
Re: expdp displays output in German [message #564606 is a reply to message #564605] Sun, 26 August 2012 09:00 Go to previous messageGo to next message
Andrey_R
Messages: 188
Registered: January 2012
Location: Euro-Asia
Senior Member

C:\......>expdp 'system@connstring' directory=DATA_PUMP_DIR dumpfile=TEST11.dmp schemas=TEST1 logfile=TEST11.log

Export: Release 11.2.0.1.0 - Production on ┬± └ÔÒ 26 15:26:48 2012

Copyright (c) 1982, 2009, Oracle and/or its affiliates.  All rights reserved.
Password:

Connected to: Oracle Database 11g Release 11.2.0.1.0 - 64bit Production
┬¹´¯ÙÝ Õ‗±  þÓ´¾±Û "SYSTEM"."SYS_EXPORT_SCHEMA_01":  "system/********@connstring" dire
ctory=DATA_PUMP_DIR dumpfile=TEST11.dmp schemas=TEST1 logfile=TEST11.log
┬¹´¯ÙÝ Õ‗±  ¯÷ÕÝÛÓ ± ´¯ý¯¨³■ ýÕ‗¯õÓ BLOCKS...
╬ß­ÓßÓ‗¹ÔÓÕ‗±  ¯ß·ÕÛ‗ ‗Þ´Ó SCHEMA_EXPORT/TABLE/TABLE_DATA
╬÷ÕÝÛÓ Þ‗¯ÒÓ ± ´¯ý¯¨³■ ýÕ‗¯õÓ BLOCKS: 0 KB
╬ß­ÓßÓ‗¹ÔÓÕ‗±  ¯ß·ÕÛ‗ ‗Þ´Ó SCHEMA_EXPORT/USER
╬ß­ÓßÓ‗¹ÔÓÕ‗±  ¯ß·ÕÛ‗ ‗Þ´Ó SCHEMA_EXPORT/DEFAULT_ROLE
╬ß­ÓßÓ‗¹ÔÓÕ‗±  ¯ß·ÕÛ‗ ‗Þ´Ó SCHEMA_EXPORT/TABLESPACE_QUOTA
╬ß­ÓßÓ‗¹ÔÓÕ‗±  ¯ß·ÕÛ‗ ‗Þ´Ó SCHEMA_EXPORT/PRE_SCHEMA/PROCACT_SCHEMA
├ÙÓÔÝÓ  ‗ÓßÙÞ÷Ó "SYSTEM"."SYS_EXPORT_SCHEMA_01" ¾±´Õ°Ý¯ þÓÒ­¾µÕÝÓ/Ô¹Ò­¾µÕÝÓ
******************************************************************************
ÈÓÚÙ õÓý´Ó, ÝÓþÝÓ¸ÕÝÝ¹Ú õÙ  SYSTEM.SYS_EXPORT_SCHEMA_01:
  /usr/datapump/TEST11.dmp
ÃÓõÓÝÞÕ "SYSTEM"."SYS_EXPORT_SCHEMA_01" ¾±´Õ°Ý¯ þÓÔÕ­°Õݯ Ô 15:26:34


C:\......>


I want this in english, so I'll understand what it does, and can be sure my expdp went well.
Re: expdp displays output in German [message #564607 is a reply to message #564606] Sun, 26 August 2012 09:21 Go to previous messageGo to next message
Michel Cadot
Messages: 58938
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
This is what NLS_LANG and NLS_LANGUAGE environment parameter are for.
Use them.

Regards
Michel
Re: expdp displays output in German [message #564609 is a reply to message #564607] Sun, 26 August 2012 09:31 Go to previous messageGo to next message
Andrey_R
Messages: 188
Registered: January 2012
Location: Euro-Asia
Senior Member

Right.

set nls_lang=american_america.al32utf8 resolves the issue.

Thank you.
Andrey
Re: expdp displays output in German [message #564610 is a reply to message #564609] Sun, 26 August 2012 09:39 Go to previous message
Michel Cadot
Messages: 58938
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
And thanks for the feedback, it is always appreciated.

Regards
Michel
Previous Topic: how to move all data from one tablespace to another tablespace
Next Topic: datapump Export taking long time(HUNG)
Goto Forum:
  


Current Time: Sat Aug 30 22:02:15 CDT 2014

Total time taken to generate the page: 0.10889 seconds