Oracle Tips by Burleson

Oracle 10g The Data Dictionary Individual Exceptions Summation

The first section of the Individual Scan Exceptions report, the Data Dictionary Individual Exceptions Summation, reports on whether data dictionary data is convertible or has exceptions. There are two types of exceptions that require actions, these are:

• exceed column size
   

• lossy conversion

The following output is an example for a data dictionary that contains both lossy and convertible data. Notice in the first part of the report how the column value for the column that is experiencing the lossy error is a comment line, which we can safely ignore. The worst that can happen is some of the comment line will not be converted properly.

[Data Dictionary individual exceptions]

User  : SYS
Table : SOURCE$
Column: SOURCE
Type  : VARCHAR2(4000)
Number of Exceptions         : 1        
Max Post Conversion Data Size: 4000     

ROWID              Exception Type      Size Cell Data(first 30 bytes)    
------------------ ------------------ ----- ------------------------------
AAAABHAABAAALBYABx lossy conversion           -- param entity_type       
------------------ ------------------ ----- ------------------------------

User  : SYS
Table : METASTYLESHEET
Column: STYLESHEET
Type  : CLOB
Number of Exceptions         : 0        
Max Post Conversion Data Size: 58471    

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