Category Archives: Changing the Database Character Set to AL32UTF8

Changing the Database Character Set to AL32UTF8 / UTF8

1-Installing and configuring CSSCAN in 10g and 11gcd $ORACLE_HOME/rdbms/adminset oracle_sid=sqlplus /nologSQL>conn / as sysdbaSQL>set TERMOUT ONSQL>set ECHO ONSQL>spool csminst.logSQL> START csminst.sql 2-Take full export of database as well other backups (RMAN or Hot)(Do not to use expdp ) 3-Invalid objects. … Continue reading

Posted in Changing the Database Character Set to AL32UTF8 | 1 Comment