Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: exp character set, Oracle 9i win 2000

Re: exp character set, Oracle 9i win 2000

From: Sybrand Bakker <gooiditweg_at_nospam.demon.nl>
Date: Wed, 05 Feb 2003 18:43:34 +0100
Message-ID: <a9j24vs6edksdnhivaa1ubd119ii9fjsv3@4ax.com>


On Wed, 5 Feb 2003 17:48:20 +0100, "Spacchiubet" <spacchiubet_at_tiscali.it> wrote:

>
>I need export database with exp command from Win 2000 server, I do
>
>exp user/passw file=file.dmp compress=y constraints=n indexs=n triggers=n
>
>It's ok but export with WE8MSWIN1252 character set, I need WE8ISO8859p1
>character set.
>
>What Can I do for export with my character set?
>
>In Oracle installation I setted the right character set....but..it export
>with the wrong.
>
>thank you
>
>Fabio.
>

set the NLS_LANG environment variable prior to calling export

Sybrand Bakker, Senior Oracle DBA

To reply remove -verwijderdit from my e-mail address Received on Wed Feb 05 2003 - 11:43:34 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US