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