Home » RDBMS Server » Backup & Recovery » Export using UTF8 character set
Export using UTF8 character set [message #183770] Sun, 23 July 2006 10:03 Go to next message
rafi_aamiri
Messages: 34
Registered: September 2005
Member
Hi,

My client is having a production database with default character set.

While exporting I need to export the database to create a dump with UTF8 character set.

Please let me know how to export with UTF8 option.

Thanks....
Re: Export using UTF8 character set [message #183771 is a reply to message #183770] Sun, 23 July 2006 10:06 Go to previous messageGo to next message
Frank Naude
Messages: 4502
Registered: April 1998
Senior Member
Set the NLS_LANG environment variable before exporting.

export NLS_LANG=ENGLISH.UTF8

Re: Export using UTF8 character set [message #183772 is a reply to message #183771] Sun, 23 July 2006 10:07 Go to previous messageGo to next message
rafi_aamiri
Messages: 34
Registered: September 2005
Member
thanks for the reply

whether i need to use this parameter during export
Re: Export using UTF8 character set [message #184061 is a reply to message #183772] Tue, 25 July 2006 02:59 Go to previous message
ashuj20
Messages: 12
Registered: October 2005
Location: new delhi
Junior Member
hi,

frank means:


Set the environment variable NLS_LANG before taking export. as done below.


c:> set NLS_LANG=ENGLISH.UTF8
then do export

exp userid=<user/password> file=<file.dmp>



Regards
Ashish Goel


Previous Topic: Export Problem
Next Topic: Recovery Scenario
Goto Forum:
  


Current Time: Fri Dec 02 23:15:56 CST 2016

Total time taken to generate the page: 0.07058 seconds