Re: How to exp/imp the schema data in the diff character set of oracle 8i?

From: Stephen Ashmore <sashmore_at_neonramp.com>
Date: Sun, 20 Jan 2002 09:34:21 -0600
Message-ID: <u4lort49evtb16@corp.supernews.com>

You may wish to try setting the NLS_SHARACTERSET unix environment variable to the character set you wish before you run the export. I have done the before but never with the chineese char set.

Stephen C. Ashmore
Brainbench MVP for Oracle Administration http://www.brainbench.com

"news.bentium.com" <rateng_at_163.com> wrote in message news:a2d9t3$5v9$1_at_news.cz.js.cn...
> I want to exp/imp the user schema ,The two oracle 8i character
> set is :
>
> DB a : NLS_CHARACTERSET ZHS16CGB231280 NLS_NCHAR_CHARACTERSET
ZHS16CGB231280
>
> DB b : NLS_CHARACTERSET US7ASCII NLS_NCHAR_CHARACTERSET US7ASCII
>
> I want to migrate the DB a data to DB b . I try some method, but I don't
> suceess as the chinese don't display in the client after migrate to DB b .
>
> ples help me !!! thanks .
>
>
Received on Sun Jan 20 2002 - 09:34:21 CST