Re: Export & Import with UTF8 Character Set

"Sybrand Bakker" <postbus_at_sybrandb.demon.nl> wrote in message news:<tue7ol3j07m523_at_corp.supernews.com>...
> "Sanjeev" <sanjeev.sagar_at_eds.com> wrote in message
> news:18e1746f.0111051238.30aea363_at_posting.google.com...
> > I am using Oracle 815 on Sun Solaris.
> >
> > Character set is UTF8. I have to export from user X and then import in
> > user Y. My export work without any problem. When I do import, it only
> > show my table definitions but do not load any data into it. Please see
> > below my par files
> >
> > Export Par File :
> >
> > file=export_wctables.dmp
> > indexes=n
> > constraints=n
> > log=export_wctables.log
> > grants=n
> > Tables=<list of Tables>
> >
> > Import Par File :
> >
> > FROMUSER=cms_o_2
> > TOUSER=cms_o_1
> > file=export_wctables.dmp
> > indexes=n
> > constraints=n
> > log=import_wctables.log
> > grants=n
> > IGNORE=Y
> > Tables=<list of Tables>
> >
> > there was no error in Import log file.
> >
> > Any help would be appreciated. Please let me know for any more info on
> > this.
>
> Question: Do you have the NLS_LANG environment variable set?
> If not, your data has been converted during export (which should show in the
> log) to US7ASCII
>
> Hth

YES I did set the NLS_LANG=UTF8 before export. I did check it before Import.

Thanks, Received on Tue Nov 06 2001 - 09:38:41 CST