transfer data from oracle 8i to 8

[chochoo]

hi gurus!
i'm new comer to this field. well my problem is that i've dual booting in my pc, running oracle 8 in win98 & oracle 8.1.7 in win2000. for some reason i want to transfer the data( a user with its complete tables) of 8i to 8. is there any solution? if yes then what is that. plz tell me step by step. it will be very kind of you

 

[sem]

Did you already try exp/imp?

Regards, Dima

 

[chochoo]

yup i tried it and it is not working means the characterset is mismatching.

 

[sem]

Do you use the same charsets on both databases? Same NLS_LANG environment variables?

Regards, Dima

 

[chochoo]

No i'm not doing so. is there a way to set them same on both ends. suppose i set the nls_lang of oracle 8 to the same of oracle 8i. will it solve the problem? and after importing databases i set the nls_lang of oracle 8 back to previous one? or it should remain the changed one?

 

[sem]

First of all it may depend on your database charsets: if your target database is US7ASCII then you may loose data if source has wider set. Then the same may occur between server and client. Can you specify all 4 variables: client NLS_LANGs and database NLS_CHARACTERSETs?

Regards, Dima