character set conversion from WE8ISO8859P1 to AL32UTF8
Hi,
I am Trying to do character set conversion from WE8ISO8859P1 to AL32UTF8. I did ran the csscan, from the log files I could see any data loss, only convertibles are there.
But there is a line which scares me given below: Now I dont whether to run the Csalter or not?
The data dictionary can not be safely migrated using the CSALTER script
Can any one please help me to resolve this. I have also copied the log file I got after running csscan. Now I want to can I run the csalter or not?
Database Scan Summary Report
Time Started : 2009-05-15 14:17:19
Time Completed: 2009-05-15 19:20:44
Process ID Time Started Time Completed
---------- -------------------- --------------------
1 2009-05-15 14:24:53 2009-05-15 19:20:28
---------- -------------------- --------------------
[Database Size]
Tablespace Used Free Total Expansion
------------------------- --------------- --------------- --------------- ---------------
SYSTEM 1,018.00M 2.00M 1,020.00M 692.00K
UNDOTBS1 517.31M 307.69M 825.00M .00K
SYSAUX 523.31M 6.69M 530.00M 72.75M
TEMP .00K .00K .00K .00K
USERS 265.38M 27.13M 292.50M .00K
XDB 94.63M 5.38M 100.00M .00K
PORTAL 114.19M 15.81M 130.00M 13.00K
PORTAL_DOC 1.25M 38.75M 40.00M .00K
PORTAL_IDX 39.56M 10.44M 50.00M .00K
PORTAL_LOG 576.00K 49.44M 50.00M .00K
IAS_META 198.75M 101.25M 300.00M .00K
------------------------- --------------- --------------- --------------- ---------------
Total 21,219.34M 1,189.44M 22,408.78M 73.44M
The size of the largest CLOB is 1057494 bytes
[Database Scan Parameters]
Parameter Value
------------------------------ ------------------------------------------------
CSSCAN Version v2.1
Instance Name swisscom
Database Version 10.2.0.4.0
Scan type Full database
Scan CHAR data? YES
Database character set WE8ISO8859P1
FROMCHAR WE8ISO8859P1
TOCHAR AL32UTF8
Scan NCHAR data? NO
Array fetch buffer size 1024000
Number of processes 1
Capture convertible data? YES
------------------------------ ------------------------------------------------
[Scan Summary]
All character type data in the data dictionary are convertible to the new character set
All character type application data are convertible to the new character set
[Data Dictionary Conversion Summary]
Datatype Changeless Convertible Truncation Lossy
--------------------- ---------------- ---------------- ---------------- ----------------
VARCHAR2 8,582,929 2 0 0
CHAR 1,249 0 0 0
LONG 440,894 0 0 0
CLOB 15,400 6,554 0 0
VARRAY 8,168 0 0 0
--------------------- ---------------- ---------------- ---------------- ----------------
Total 9,048,640 6,556 0 0
Total in percentage 99.928% 0.072% 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 1,011,332 5 0 0
CHAR 470,216 0 0 0
LONG 32,812 0 0 0
CLOB 246 35 0 0
VARRAY 132 0 0 0
--------------------- ---------------- ---------------- ---------------- ----------------
Total 1,514,738 40 0 0
Total in percentage 99.997% 0.003% 0.000% 0.000%
[Distribution of Convertible, Truncated and Lossy Data by Table]
USER.TABLE Convertible Truncation Lossy
-------------------------------------------------- ---------------- ---------------- ----------------
NIKIRA_SWS.SWISSCOM_CONTRACT 4 0 0
OCA.OCM_JAZN 1 0 0
PORTAL.WWA_FORM$ 33 0 0
PORTAL.WWV_TEXT 1 0 0
SWISSCOM.SWISSCOM_CONTRACT 1 0 0
SYS.METASTYLESHEET 80 0 0
SYS.RULE$ 12 0 0
SYS.SCHEDULER$_EVENT_LOG 8 0 0
SYS.SOURCE$ 2 0 0
SYS.WRH$_SQLTEXT 1,289 0 0
SYS.WRH$_SQL_PLAN 1,277 0 0
SYS.WRI$_ADV_ACTIONS 1,704 0 0
SYS.WRI$_ADV_OBJECTS 1,219 0 0
SYS.WRI$_ADV_RATIONALE 839 0 0
SYS.WRI$_DBU_FEATURE_METADATA 98 0 0
SYS.WRI$_DBU_FEATURE_USAGE 9 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
-------------------------------------------------- ---------------- ---------------- ----------------
NIKIRA_SWS.SWISSCOM_CONTRACT|CONTRACT_STREET_NAME 4 0 0
OCA.OCM_JAZN|JAZN_DATA 1 0 0
PORTAL.WWA_FORM$|JS_CODE 6 0 0
PORTAL.WWA_FORM$|JS_LIB 6 0 0
PORTAL.WWA_FORM$|LAYOUT_BODY 7 0 0
PORTAL.WWA_FORM$|LAYOUT_FOOTER 7 0 0
PORTAL.WWA_FORM$|LAYOUT_HEADER 7 0 0
PORTAL.WWV_TEXT|TEXT 1 0 0
SWISSCOM.SWISSCOM_CONTRACT|CONTRACT_STREET_NAME 1 0 0
SYS.METASTYLESHEET|STYLESHEET 80 0 0
SYS.RULE$|CONDITION 12 0 0
SYS.SCHEDULER$_EVENT_LOG|ADDITIONAL_INFO 8 0 0
SYS.SOURCE$|SOURCE 2 0 0
SYS.WRH$_SQLTEXT|SQL_TEXT 1,289 0 0
SYS.WRH$_SQL_PLAN|OTHER_XML 1,277 0 0
SYS.WRI$_ADV_ACTIONS|ATTR5 852 0 0
SYS.WRI$_ADV_ACTIONS|ATTR6 852 0 0
SYS.WRI$_ADV_OBJECTS|ATTR4 1,219 0 0
SYS.WRI$_ADV_RATIONALE|ATTR5 839 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 9 0 0
SYS.WRI$_DBU_HWM_METADATA|LOGIC 19 0 0
-------------------------------------------------- ---------------- ---------------- ----------------
[Indexes to be Rebuilt]
USER.INDEX on USER.TABLE(COLUMN)
-----------------------------------------------------------------------------------------
-----------------------------------------------------------------------------------------
It is bit urgent..... need help ASAP
Thanks in advance
With Regards
Boo