OraFAQ Forum: Backup & Recovery » Export using UTF8 character set

Home » RDBMS Server » Backup & Recovery » Export using UTF8 character set

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

Export using UTF8 character set [message #183770]

Sun, 23 July 2006 10:03

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

Report message to a moderator

Re: Export using UTF8 character set [message #183771 is a reply to message #183770]

Sun, 23 July 2006 10:06

Frank Naude
Messages: 4579
Registered: April 1998

Senior Member

Set the NLS_LANG environment variable before exporting.

export NLS_LANG=ENGLISH.UTF8

Report message to a moderator

Re: Export using UTF8 character set [message #183772 is a reply to message #183771]

Sun, 23 July 2006 10:07

rafi_aamiri
Messages: 34
Registered: September 2005

Member

thanks for the reply

whether i need to use this parameter during export

Report message to a moderator

Re: Export using UTF8 character set [message #184061 is a reply to message #183772]

Tue, 25 July 2006 02:59

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

Report message to a moderator

Previous Topic:	Export Problem
Next Topic:	Recovery Scenario

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Apr 24 11:34:08 CDT 2024