Oracle Tips by Burleson

Oracle 10g The Application Data Conversion Summary

The next report section, the Application Data Conversion Summary, contains the statistics on the conversion of the application data. The number of data objects with each status category are listed by datatype.

[Application Data Conversion Summary]

Datatype              Changeless   Convertible    Truncation       Lossy
------------------ ------------- ------------- ------------- -----------
VARCHAR2                 604,280             0             0           0
CHAR                       1,221             0             0           0
LONG                           0             0             0           0
CLOB                          28             1             0           0
------------------ ------------- ------------- ------------- -----------
Total                    605,529             1             0           0
Total in percentage     100.000%        0.000%        0.000%      0.000%

The possible status categories are:

• Changeless -- This category is used for data that remains the same in the new character set.
   

• Convertible -- This category is used for data that can be successfully converted to the new character set.
   

• Truncation -- This category is used for data that will require truncation if conversion takes place.
   

• Lossy -- This character is used for datatypes containing character data that will be lost if conversion takes place.

The next report sub-section is for application data conversion summary per column size report. 

Get the complete Oracle10g story:

The above text is an excerpt from "Oracle Database 10g New Features: Oracle10g Reference for Advanced Tuning and Administration", by Rampant TechPress.  Written by top Oracle experts, this book has a complete online code deport with ready to use scripts. 

To get the code instantly, click here:

http://rampant-books.com/book_2003_2_oracle10g.htm