Export & Import with UTF8 Character Set 
Author Message
 Export & Import with UTF8 Character Set

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.



Sat, 24 Apr 2004 04:38:31 GMT
 Export & Import with UTF8 Character Set


Quote:
> 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



Sat, 24 Apr 2004 05:33:10 GMT
 Export & Import with UTF8 Character Set

Quote:



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



Sat, 24 Apr 2004 23:38:41 GMT
 Export & Import with UTF8 Character Set

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

If you do not fully ("full=y") export your database (only tables) use
"rows=y" or "inctype=complete" export's parameters for exporting data.

--




Sat, 24 Apr 2004 15:58:48 GMT
 
 [ 4 post ] 

 Relevant Pages 

1. Character set conversion to UTF8 from WE8ISO8859P1 to UTF8

2. Characters beyond ASCII in database ( US7ASCII and UTF8 character set )

3. Export-Import across character sets

4. Export/import from different character sets

5. Export/import and characters set.

6. Problems with character set after Export/Import

7. db character set & N character set

8. database character sets utf8

9. character set conversion: AL24UTFFSS to UTF8

10. Non supported character set: oracle-character-set-96

11. Import/Export with multiple-character delimiter?

12. Export/Import 7.2.2 (OS/2) - 7.3.4 (NT) French characters problem


 
Powered by phpBB® Forum Software