| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Import Characterset problem
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:Received on Tue Jan 08 2002 - 05:29:26 CST
>
>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 <ahussain_at_gisqatar.org.qa> 08/01/2002 02:30 PM
>Sent by: root_at_fatcity.com
>
>Please respond to ORACLE-L
>
>
> To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
>
> 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:NIRMALK_at_qtel.com.qa]
>> 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:ahussain_at_gisqatar.org.qa]
>> > 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:NIRMALK_at_qtel.com.qa]
>> > > 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: ahussain_at_gisqatar.org.qa
>> >
>> > 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: ListGuru_at_fatcity.com (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: ahussain_at_gisqatar.org.qa
>
>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: ListGuru_at_fatcity.com (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: hemantchitale_at_charteredsemi.com
>
>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: ListGuru_at_fatcity.com (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: csvenkata_at_lycos.com 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: ListGuru_at_fatcity.com (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).
 |
 |