EXP/IMP WE8ISO8859P1/US7ASCII issues 
Author Message
 EXP/IMP WE8ISO8859P1/US7ASCII issues

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.


Tue, 19 Jun 2001 03:00:00 GMT
 EXP/IMP WE8ISO8859P1/US7ASCII issues

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.



Tue, 19 Jun 2001 03:00:00 GMT
 EXP/IMP WE8ISO8859P1/US7ASCII issues

Hi Sanjay,

There is a different and better option: recreate the Unix database with the
WE8ISO8859P1 characterset. US7ASCII is a 7-bit characterset and WE8ISO8859P1
8-bit. You will always loose information when converting 8-bit to 7-bit, which
is probably the reason why it is disallowed or doesn't work with import. Make
sure you have NLS installed on the Unix box though (this is not installed using
the default install).
Some people have explained earlier in this newsgroup it is possible to update
the table sys.prop$ to change the characterset. While this method seems to work,
it is definitely unsupported by Oracle.

Hth and best wishes,

Sybrand Bakker, Oracle DBA

Quote:

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

  postbus.vcf
< 1K Download


Tue, 19 Jun 2001 03:00:00 GMT
 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).
===========================================

Quote:

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



Wed, 20 Jun 2001 03:00:00 GMT
 EXP/IMP WE8ISO8859P1/US7ASCII issues
On Fri, 01 Jan 1999 19:57:47 +0100, Sybrand Bakker

Quote:

>Some people have explained earlier in this newsgroup it is possible to update
>the table sys.prop$ to change the characterset. While this method seems to work,
>it is definitely unsupported by Oracle.

Given that this is the instruction given in the manuals, how is it
unsupported?


Wed, 20 Jun 2001 03:00:00 GMT
 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

Quote:

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



Thu, 21 Jun 2001 03:00:00 GMT
 
 [ 6 post ] 

 Relevant Pages 

1. exp data from WE8ISO8859P1 and imp in UTF8

2. Problems going from US7ASCII to WE8ISO8859P1

3. US7ASCII to WE8ISO8859P1

4. changing nls_characters set from US7ASCII to WE8ISO8859P1 in Oracle 8.0.5

5. CONVERTing to US7ASCII from WE8ISO8859P1

6. Expor from US7ASCII(7bit) and Importing into WE8ISO8859P1(8bit) Characterset using Oracle8

7. PUBLIC:Re: Expor from US7ASCII(7bit) and Importing into WE8ISO8859P1(8bit) Characterset using Oracle8

8. imp 00038 when modifying exp file and running imp

9. MSSQL Exp/Imp question

10. Howto get a row by its number (as reported in a DTS imp/exp error)

11. MSSQL Exp/Imp question

12. equivalent of Oracle exp/imp for Sql Server?


 
Powered by phpBB® Forum Software