Database Software

Hello,

I was today changing character set from EE8MSWIN1250 to AL32UTF8 in oracle 10.2.0.1, which failed, here is the scan summary please do give me best suggestion how i can go a head with it.

Database Scan Summary Report

Time Started : 2012-01-12 20:50:20
Time Completed: 2012-01-12 21:20:54

Process ID Time Started Time Completed
---------- -------------------- --------------------
1 2012-01-12 20:54:39 2012-01-12 21:19:57
2 2012-01-12 20:54:39 2012-01-12 21:20:20
3 2012-01-12 20:54:39 2012-01-12 21:20:37
4 2012-01-12 20:54:39 2012-01-12 21:19:57
5 2012-01-12 20:54:41 2012-01-12 21:19:56
6 2012-01-12 20:54:39 2012-01-12 21:20:43
7 2012-01-12 20:54:40 2012-01-12 21:19:56
8 2012-01-12 20:54:40 2012-01-12 21:19:57
9 2012-01-12 20:54:41 2012-01-12 21:19:57
10 2012-01-12 20:54:42 2012-01-12 21:19:56
11 2012-01-12 20:54:41 2012-01-12 21:20:39
12 2012-01-12 20:54:42 2012-01-12 21:19:57
13 2012-01-12 20:54:41 2012-01-12 21:19:56
14 2012-01-12 20:54:42 2012-01-12 21:19:57
15 2012-01-12 20:54:40 2012-01-12 21:19:57
16 2012-01-12 20:54:42 2012-01-12 21:19:56
17 2012-01-12 20:54:40 2012-01-12 21:19:56
18 2012-01-12 20:54:43 2012-01-12 21:19:56
19 2012-01-12 20:54:40 2012-01-12 21:20:49
20 2012-01-12 20:54:42 2012-01-12 21:20:52
21 2012-01-12 20:54:40 2012-01-12 21:20:21
22 2012-01-12 20:54:42 2012-01-12 21:19:57
23 2012-01-12 20:54:40 2012-01-12 21:19:56
24 2012-01-12 20:54:43 2012-01-12 21:19:56
25 2012-01-12 20:54:41 2012-01-12 21:19:56
26 2012-01-12 20:54:43 2012-01-12 21:19:57
27 2012-01-12 20:54:41 2012-01-12 21:19:56
28 2012-01-12 20:54:43 2012-01-12 21:19:57
29 2012-01-12 20:54:42 2012-01-12 21:19:56
30 2012-01-12 20:54:43 2012-01-12 21:19:57
31 2012-01-12 20:54:43 2012-01-12 21:19:57
32 2012-01-12 20:54:43 2012-01-12 21:19:57
---------- -------------------- --------------------

[Database Size]

Tablespace Used Free Total Expansion
------------------------- --------------- --------------- --------------- ---------------
SYSTEM 693,50M 26,50M 720,00M 1,06M
UNDOTBS1 59,50M 1 150,50M 1 210,00M ,00K
SYSAUX 438,19M 11,81M 450,00M 8,62M
TEMP ,00K ,00K ,00K ,00K
USERS 3,13M 1,88M 5,00M ,00K
EXAMPLE 77,38M 22,63M 100,00M 108,00K
PDESRV 2 771,25M 228,75M 3 000,00M 758,03M
PDEVEGY 1 394,06M 105,94M 1 500,00M 3,73M
PDEREN 1 270,63M 229,38M 1 500,00M 3,89M
------------------------- --------------- --------------- --------------- ---------------
Total 6 707,63M 1 777,38M 8 485,00M 775,42M

The size of the largest CLOB is 3982807 bytes

[Database Scan Parameters]

Parameter Value
------------------------------ ------------------------------------------------
CSSCAN Version v2.1
Instance Name pdent
Database Version 10.2.0.1.0
Scan type Full database
Scan CHAR data? YES
Database character set EE8MSWIN1250
FROMCHAR EE8MSWIN1250
TOCHAR AL32UTF8
Scan NCHAR data? NO
Array fetch buffer size 1024000
Number of processes 32
Capture convertible data? NO
------------------------------ ------------------------------------------------

[Scan Summary]

Some character type data in the data dictionary are not convertible to the new character set
Some character type application data are not convertible to the new character set

[Data Dictionary Conversion Summary]

Datatype Changeless Convertible Truncation Lossy
--------------------- ---------------- ---------------- ---------------- ----------------
VARCHAR2 5 888 961 19 608 0 0
CHAR 1 097 0 0 0
LONG 311 066 579 0 0
CLOB 25 204 1 901 0 1
VARRAY 22 366 0 0 0
--------------------- ---------------- ---------------- ---------------- ----------------
Total 6 248 694 22 088 0 1
Total in percentage 99,648% 0,352% 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 8 246 189 1 248 156 800 0
CHAR 1 024 547 0 0 0
LONG 18 639 30 0 0
CLOB 615 152 7 410 0 0
VARRAY 2 019 0 0 0
--------------------- ---------------- ---------------- ---------------- ----------------
Total 9 906 546 1 255 596 800 0
Total in percentage 88,745% 11,248% 0,007% 0,000%

[Distribution of Convertible, Truncated and Lossy Data by Table]

i pasted its half as the summary is too long, i am very new please do help me out.

thanks and Regards
Firdous
-------