Verifying a Database After Migrating to Unicode:

Verify the following after DMU conversion is complete:

1. The NLS parameters should be AL32UTF8 and CHAR:

   select * from V$NLS_PARAMETERS where parameter in ('NLS_CHARACTERSET','NLS_LENGTH_SEMANTICS');

2. The PSSTATUS field of UNICODE_ENABLED should be 1:

   select unicode_enabled from psstatus;

3. There should be only two columns with CHAR_USED as B: PTIA_VWNAME and PTIA_VWDEPNAME:

   SELECT TABLE_NAME, COLUMN_NAME, DATA_TYPE, CHAR_USED FROM USER_TAB_COLUMNS WHERE DATA_TYPE='VARCHAR2' AND CHAR_USED='B';

4. Run Audit:

   Run the audits such as DDDAUDIT, SYSAUDIT, and an Alter Audit. There should be no new SYSAUDIT or DDDAUDIT exceptions that were not there before the migration.

Note:

These checks also apply to any database that is Unicode and is not specific to DMU migrations.