RE: Import Characterset problem

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