Updates

    CSSCAN Utility and CSALTER Script:

    Database character set migration has two stages: data scanning (csscan) and data conversion (csalter.plb).

    The CSSCAN Utility is used to denitrify possible database character set conversion problems and truncation of data. Data scanning identifies the amount of effort required to migrate data into the new character encoding scheme before changing the database character set. This information helps to determine the best approach for converting the database character set.

    The CSALTER script is part of the Database Character Set Scanner utility. The CSALTER script is the most straightforward way to migrate a character set, but it can be used only if all of the schema data is a strict subset of the new character set. The new character set is a strict superset of the current character set if:

    Each and every character in the current character set is available in the new character set.

    Each and every character in the current character set has the same code point value in the new character set.

    0 comments:

    Post a Comment

    Copyright © ORACLE ONLINE DBA
    Developed By Pavan Yennampelli