Re: Import/Export problem

UPDATE SYS.PROPS$ set value='WE8DEC' where name='NLS_CHARACTERSET';

You may be need to add 8th bit code table support before by Oracle Installer without tuching DB.

You will get 8th bit DB.

Steven Teo <teobc_at_hpsgmx18.sgp.hp.com> wrote in article <355C560A.3259F88F_at_hpsgmx18.sgp.hp.com>...
> Hi,
> What about CHAR_SET, NLS issues? We have a database with CHAR_SET or
> NLS_LANG set to US7-ASCII... however, there are 8-bit characters stored
> in the database. As a side effect, it works. Now, we are trying to
> export the data and import it into an 8-bit Char_SET, and translation
> occurs, and the 8th bit is lost.. resulting in data lost... any way to
> get around this?
>
> I was thinking exporting the data in US_7ASCII to a dmp file.. and
> then modify the DMP file to the 8-bit char set before importing... ??
>
> Steve
>
>
>
>
Received on Tue May 19 1998 - 00:00:00 CEST