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).
<<application/ms-tnef>>
