Actually you won't have to do a characterset conversion because WE8ISO8859P1 is a superset of US7ASCII. But this message is just telling you that it might do a conversion . Set the characterset to WE8ISO8859P1 on the server at the command line prompt and everything should go OK.
HTH, Ruth ----- Original Message ----- To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Wednesday, February 13, 2002 4:38 AM > Hi folks, > > since a 3rd-party application vendor came in to upgrade their app., and also > to upgrade the version of Oracle from 7.3.4 to 8i, I've noticed the > following messages whenever I export or import tables on the database: > > On EXPORT: > > Connected to: Oracle8i Enterprise Edition Release 8.1.7.0.0 - Production > With the Partitioning option > JServer Release 8.1.7.0.0 - Production > Export done in US7ASCII character set and WE8ISO8859P1 NCHAR character set > server uses WE8ISO8859P1 character set (possible charset conversion) > > On IMPORT: > > Connected to: Oracle8i Enterprise Edition Release 8.1.7.0.0 - Production > With the Partitioning option > JServer Release 8.1.7.0.0 - Production > Export file created by EXPORT:V08.01.07 via conventional path > import done in US7ASCII character set and WE8ISO8859P1 NCHAR character set > import server uses WE8ISO8859P1 character set (possible charset conversion) > > So what I'd like to know is whether these messages about possible charset > conversion are anything to worry about? If not, then are there any > performance issues arising from these charset conversions? I ask because the > imports seem to run really slowly compared with imports on some of our other > servers, and if character sets are being converted for every imported row, I > guess that might account for it! So are there any "gotchas" I should be > aware of here? > > Thanks - hope somebody can offer some insights! > > Paul > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Paul Vincent > 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: Ruth Gramolini 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).
