 |
|
Oracle Tips by Burleson |
Oracle 10g Distribution of Convertible and Exceptional
Data per Column
[Distribution
of Convertible and Exceptional Data per Column]
USER.TABLE|COLUMN Convertible
Truncation Lossy
----------------------------- ---------------- ----------------
----------------DMSYS.DM$PMML_DTD|DTD
1 0 0
SYS.METASTYLESHEET|STYLESHEET 80
0 0
SYS.RULE$|CONDITION 4
0 0
SYS.SOURCE$|SOURCE 0
0 1
----------------------------- ---------------- ----------------
----------------
[Indexes to
be Rebuilt]
USER.INDEX on
USER.TABLE(COLUMN)
-----------------------------------------------------------------------
-----------------------------------------------------------------------
The error
report (scan.err) tells us a bit more about the error entry:
Database Scan
Individual Exception Report
[Database
Scan Parameters]
Parameter
Value
------------------------------
------------------------------------------------
CSSCAN Version v1.2
Instance Name aultdb1
Database Version 10.1.0.0.0
Scan type Full database
Scan CHAR data? YES
Database character set
WE8ISO8859P1
FROMCHAR
WE8ISO8859P1
TOCHAR
ZHS16CGB231280
Scan NCHAR data? NO
Array fetch buffer size 40960
Number of processes 1
Capture convertible data?
NO
------------------------------
------------------------------------------------
Get the complete Oracle10g story:
To get the code instantly, click here:
|
|
|
Need an Oracle Health Check?
Does your boss blame you for an Oracle performance problem?
Need to prove that your database is properly optimized?
BC Oracle performance guru's can quickly verify every aspect of your
Oracle database and provide a complete certification that your database
is fully optimized. |
|
|
