Forums | Aggregator | Books | Industry News | Firefox Plugins | Social | Links

Comments

Character Set Migration using CSSCAN and CSALTER - Change the default character set of your database using the character set scanning utilities provided by Oracle.



Mario said...

I think that it would be better add a note that talk about the file scan.txt with the results of the first step.

by

Mario said...

you have to verify that no user are connected (es. sysman).
Be sure that EM is down (emctl stop dbconsole)

Tim... said...

I think you're getting into the obvious here!

Mario said...

I'm sorry for the obvious ... I have another note for you. If you change charset you can find this error message in the alert.log:

WARNING: AQ_TM_PROCESSES is set to 0. System operation might be adversely affected.

see metalink Note:428441.1 to unset the parameter.
I have found it changing from WE8ISO8859P1 to WE8ISO8859P15 (two times on two different databases).
Prepared Statement Error: Table './oraclebasecms/cms_page_comment_uuids' is marked as crashed and should be repaired