Re: Export & Import with UTF8 Character Set

"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

--
Sybrand Bakker
Senior Oracle DBA

to reply remove '-verwijderdit' from my e-mail address