Database Scan Summary Report Time Started : 2009-04-21 12:07:59 Time Completed: 2009-04-21 12:12:13 Process ID Time Started Time Completed ---------- -------------------- -------------------- 1 2009-04-21 12:08:16 2009-04-21 12:12:12 2 2009-04-21 12:08:16 2009-04-21 12:12:12 3 2009-04-21 12:08:17 2009-04-21 12:12:12 4 2009-04-21 12:08:17 2009-04-21 12:12:12 ---------- -------------------- -------------------- [Database Size] Tablespace Used Free Total Expansion ------------------------- --------------- --------------- --------------- --------------- SYSTEM 501.50M 8.50M 510.00M 692.00K UNDOTBS1 20.31M 794.69M 815.00M .00K SYSAUX 340.56M 9.44M 350.00M 15.29M TEMP .00K .00K .00K .00K USERS 448.00K 4.56M 5.00M .00K ILS3_1MB_DATA03 1,475.56M 64.00K 1,475.63M .00K ------------------------- --------------- --------------- --------------- --------------- Total 2,338.38M 817.25M 3,155.63M 15.97M The size of the largest CLOB is 1625114 bytes [Database Scan Parameters] Parameter Value ------------------------------ ------------------------------------------------ CSSCAN Version v2.1 Instance Name ils10gdc Database Version 10.2.0.4.0 Scan type Full database Scan CHAR data? YES Database character set WE8ISO8859P1 FROMCHAR WE8ISO8859P1 TOCHAR UTF8 Scan NCHAR data? NO Array fetch buffer size 1024000 Number of processes 4 Capture convertible data? YES ------------------------------ ------------------------------------------------ [Scan Summary] Some character type data in the data dictionary are not convertible to the new character set All character type application data remain the same in the new character set [Data Dictionary Conversion Summary] Datatype Changeless Convertible Truncation Lossy --------------------- ---------------- ---------------- ---------------- ---------------- VARCHAR2 4,272,992 0 0 0 CHAR 1,106 0 0 0 LONG 157,476 0 0 0 CLOB 83,508 3,392 0 6 VARRAY 22,432 0 0 0 --------------------- ---------------- ---------------- ---------------- ---------------- Total 4,537,514 3,392 0 6 Total in percentage 99.925% 0.075% 0.000% 0.000% The data dictionary can not be safely migrated using the CSALTER script [Application Data Conversion Summary] Datatype Changeless Convertible Truncation Lossy --------------------- ---------------- ---------------- ---------------- ---------------- VARCHAR2 24,918,847 0 0 0 CHAR 750 0 0 0 LONG 3 0 0 0 CLOB 0 0 0 0 VARRAY 1,575 0 0 0 --------------------- ---------------- ---------------- ---------------- ---------------- Total 24,921,175 0 0 0 Total in percentage 100.000% 0.000% 0.000% 0.000% [Distribution of Convertible, Truncated and Lossy Data by Table] USER.TABLE Convertible Truncation Lossy -------------------------------------------------- ---------------- ---------------- ---------------- MDSYS.SDO_COORD_OP_PARAM_VALS 200 0 0 MDSYS.SDO_GEOR_XMLSCHEMA_TABLE 1 0 0 MDSYS.SDO_STYLES_TABLE 78 0 0 MDSYS.SDO_XML_SCHEMAS 3 0 0 SYS.METASTYLESHEET 80 0 0 SYS.RULE$ 1 0 0 SYS.WRH$_SQLTEXT 822 0 2 SYS.WRH$_SQL_PLAN 742 0 0 SYS.WRI$_ADV_ACTIONS 640 0 0 SYS.WRI$_ADV_OBJECTS 365 0 4 SYS.WRI$_ADV_RATIONALE 335 0 0 SYS.WRI$_DBU_FEATURE_METADATA 98 0 0 SYS.WRI$_DBU_FEATURE_USAGE 8 0 0 SYS.WRI$_DBU_HWM_METADATA 19 0 0 -------------------------------------------------- ---------------- ---------------- ---------------- [Distribution of Convertible, Truncated and Lossy Data by Column] USER.TABLE|COLUMN Convertible Truncation Lossy -------------------------------------------------- ---------------- ---------------- ---------------- MDSYS.SDO_COORD_OP_PARAM_VALS|PARAM_VALUE_FILE 200 0 0 MDSYS.SDO_GEOR_XMLSCHEMA_TABLE|XMLSCHEMA 1 0 0 MDSYS.SDO_STYLES_TABLE|DEFINITION 78 0 0 MDSYS.SDO_XML_SCHEMAS|XMLSCHEMA 3 0 0 SYS.METASTYLESHEET|STYLESHEET 80 0 0 SYS.RULE$|CONDITION 1 0 0 SYS.WRH$_SQLTEXT|SQL_TEXT 822 0 2 SYS.WRH$_SQL_PLAN|OTHER_XML 742 0 0 SYS.WRI$_ADV_ACTIONS|ATTR5 320 0 0 SYS.WRI$_ADV_ACTIONS|ATTR6 320 0 0 SYS.WRI$_ADV_OBJECTS|ATTR4 365 0 4 SYS.WRI$_ADV_RATIONALE|ATTR5 335 0 0 SYS.WRI$_DBU_FEATURE_METADATA|INST_CHK_LOGIC 12 0 0 SYS.WRI$_DBU_FEATURE_METADATA|USG_DET_LOGIC 86 0 0 SYS.WRI$_DBU_FEATURE_USAGE|FEATURE_INFO 8 0 0 SYS.WRI$_DBU_HWM_METADATA|LOGIC 19 0 0 -------------------------------------------------- ---------------- ---------------- ---------------- [Indexes to be Rebuilt] USER.INDEX on USER.TABLE(COLUMN) ----------------------------------------------------------------------------------------- -----------------------------------------------------------------------------------------