Re: Import/Export problem

Lets remember updating the $ tables, if not all, most cases will cause oracle to not have to support you. I have yet to see a case where when updating a $ table, oracle WILL support you if something goes wrong. SO take doing those updates with that in mind.

joe
http://www.oracle-dba.com

Slava Krivonos wrote:

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

--
Joseph S. Testa, Oracle Database Administrator
Vice-President Ohio Oracle Users Group, http://www.ooug.org
OOUG welcomes Steven Feuerstein to Columbus OH in Oct, if your company is
interested in becoming a corporate sponsor for this event, send
mailto:vice_pres_at_ooug.org.
Want some remote DBA work done? mailto:teci_at_oracle-dba.com
ICQ http://wwp.mirabilis.com/2832230