With the end-goal of doing a character set conversion from US7ASCII to UTF8, I have run csminst.sql to create work tables and then run the CSSCAN utility from rdbms/admin on my test database.
We have written a C program to identify and alter exceptional characters identified by the CSSCAN utility to valid US7ASCII characters. I then reran csminst.sql and reran CSSCAN utility. Exactly the same number of exceptions were identified by the rescan as were identified in the original character set scan. Either I am missing a step or the C program is not actually replacing the bad characters. Anyone know of some step I need to take to clear out my work files before I rerun the character set scan? I don't see anything in the Notes on Metalink for rerunning csscan on the same database? Cherie -- 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).