Re: EXP/IMP WE8ISO8859P1/US7ASCII issues

I had the same problem before, Iwas about ready to recreate the database on the unix system with the WE8ISO8859P1. I decided to try test updating the PROPS$ table on my personal database, it worked. One thing that you should pay attention to is to use capital letters when updating the PROPS$ table, use it with carefull, otherwise you won't be able to restart the database. And I do thing it is not supported by Oracle.

Good Luck;

Wasim
Sanjay Hans wrote in message <76ill3$2fj$1_at_mango.singnet.com.sg>...
>I have a oracle 7.3 database on Unix which was created with US7ASCII
>character set and a Oracle 7.3 database on NT 4.0 which was created with
>WE8ISO8859P1 character set. We used this character sets because on Unix
OS
>US7ASCCII is the default character set and on Windows NT WE8ISO8859P1 is
the
>default character set.
> The problem which I am facing is, I can take export backup from Oracle 7.3
>(US7ASCII character set) on Unix and import it on Oracle 7.3 (WE8ISO8859P1
>character set ) on NT 4.0 but I am not able to do the other way, i.e. take
>export backup from Oracle 7.3 (WE8ISO8859P1 character set ) on NT 4.0 and
>import it on Oracle 7.3 (US7ASCII character set) on Unix. Should I create
>Oracle database on NT 4.0 with US7ASCII character set?
>Would appreciate your help/suggestions.
>Thanks in advance.
>
>
>
>
Received on Sun Jan 03 1999 - 03:29:03 CST