RE: Import Characterset problem

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