| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Usenet -> c.d.o.server -> Re: EXP/IMP WE8ISO8859P1/US7ASCII issues
WE8ISO8859P1 is a superset of US7ASCII (as its characters are storred
in 8 bits rather than 7) hence to move to 7 bit some conversion would
be necessary. Obviously (I hope) Oracle can't do this. Hence you need
to create a new db on your Unix machine remembering to use the
WE8ISO8859P1 charset. Then EXP/IMP and Bob's your uncle.
Aside: do NOT use direct path EXP - the IMP takes about 15 times as long.
Eugene (Oracle Certified dba looking for job on NT or VMS).
> 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 Fri Jan 01 1999 - 20:05:31 CST
 |
 |