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

<<application/ms-tnef>> Received on Tue Jan 08 2002 - 00:09:03 CST