Try setting the NLS_LANG parameter to the desired value before importing. If it is NT/2000 change it in the registry. If it is in Unix then set it as environment variable.
HTH Venkat -- On Tue, 08 Jan 2002 01:25:23 hemantchitale wrote: > >Nirmal, > >Don't try updating SYS.PROPS$. >1. It is not supported. >2. If you make a mistake (an extra space, a mis-spelled value) >you will NOT be able to start the database at all. >3. I seriously doubt you can convert US7ASCII to AR8MSWIN1256. >4. The ALTER DATABASE CONVERT CHARACTERSET would also not work. > >Log a TAR with Oracle Support. >You would most probably have to recreate your US7ASCII database as an >AR8MSWIN1256 Database. > >Hemant K Chitale >Principal DBA >Chartered Semiconductor Manufacturing Ltd > > >Ahmed Gholam Hussain <[EMAIL PROTECTED]> 08/01/2002 02:30 PM >Sent by: [EMAIL PROTECTED] > >Please respond to ORACLE-L > > > To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> > > cc: (bcc: CHITALE Hemant Krishnarao/Prin DBA/CSM/ST Group) > > Subject: RE: Import Characterset problem > > > > > > > > > > > > >Hi Nirmal, > > What u have to do is a normal update statement on PROPS$...I remember >doing that while there was a need to enter Arabic characters on our DB.... > >Be careful not to enter any spaces between the character set value >"AR8MSWIN1256" ..It may crash your target DB...... > >I do not recall another way of doing that .... > >HTH >Regards >Gholam > >> -----Original Message----- >> From: Nirmal Kumar Muthu Kumaran [SMTP:[EMAIL PROTECTED]] >> Sent: Tuesday, January 08, 2002 9:20 AM >> To: Multiple recipients of list ORACLE-L >> Subject: RE: Import Characterset problem >> >> Hi gholam, >> >> Thanks for ur help, by the way let me know how to change the character >set >> of DB using props$?.... >> >> Just you want me to update this props$ for nls_characterset with the new >> value?... is it recommanded one?... >> >> The exp dump file is of character set "AR8MSWIN1256", now the target db >is >> with characterset "US7ASCII". >> >> Thanks. >> >> Nirmal. >> >> > -----Original Message----- >> > From: Ahmed Gholam Hussain [SMTP:[EMAIL PROTECTED]] >> > Sent: 23 شوال, 1422 10:15 AM >> > To: Multiple recipients of list ORACLE-L >> > Subject: RE: Import Characterset problem >> > >> > Hi Nirmal , >> > >> > While importing u have to consider that the source and target databases >> > character sets should be matching U can change the character set of >your >> > target database using props$ data dictionary view .... >> > >> > HTH >> > >> > Gholam >> > >> > > -----Original Message----- >> > > From: Nirmal Kumar Muthu Kumaran [SMTP:[EMAIL PROTECTED]] >> > > Sent: Monday, January 07, 2002 10:05 AM >> > > To: Multiple recipients of list ORACLE-L >> > > Subject: Import Characterset problem >> > > >> > > Helo gurus, >> > > >> > > I exported on schema from the old datatabase and then >> > > i created new database in my PC. Now i want to import it, >> > > but it's saying that characterset is not match error. >> > > >> > > How can i rectify it .... >> > > >> > > Thanks. >> > > >> > > Nirmal. << File: ATT18366.ATT >> >> > -- >> > Please see the official ORACLE-L FAQ: http://www.orafaq.com >> > -- >> > Author: Ahmed Gholam Hussain >> > INET: [EMAIL PROTECTED] >> > >> > Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 >> > San Diego, California -- Public Internet access / Mailing Lists >> > -------------------------------------------------------------------- >> > To REMOVE yourself from this mailing list, send an E-Mail message >> > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in >> > the message BODY, include a line containing: UNSUB ORACLE-L >> > (or the name of mailing list you want to be removed from). You may >> > also send the HELP command for other information (like subscribing). << >> File: ATT19805.ATT >> >-- >Please see the official ORACLE-L FAQ: http://www.orafaq.com >-- >Author: Ahmed Gholam Hussain > INET: [EMAIL PROTECTED] > >Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 >San Diego, California -- Public Internet access / Mailing Lists >-------------------------------------------------------------------- >To REMOVE yourself from this mailing list, send an E-Mail message >to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in >the message BODY, include a line containing: UNSUB ORACLE-L >(or the name of mailing list you want to be removed from). You may >also send the HELP command for other information (like subscribing). > > > > > >-- >Please see the official ORACLE-L FAQ: http://www.orafaq.com >-- >Author: > INET: [EMAIL PROTECTED] > >Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 >San Diego, California -- Public Internet access / Mailing Lists >-------------------------------------------------------------------- >To REMOVE yourself from this mailing list, send an E-Mail message >to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in >the message BODY, include a line containing: UNSUB ORACLE-L >(or the name of mailing list you want to be removed from). You may >also send the HELP command for other information (like subscribing). > -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: C.S.Venkata Subramanian INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
