This discussion is archived
1 Reply Latest reply: Jun 30, 2011 1:16 AM by Gunther Vermeir, Oracle RSS

Can I use DMU for this database?

JCGO Newbie
Currently Being Moderated
Hi everyone,
I am snippeting a CSSCAN ( i know..) so that will reveal the amount of convertible data we have to tackle and wanted everyone's opinion if we can use DMU for this database.

[Data Dictionary Conversion Summary]

Datatype Changeless Convertible Truncation Lossy
--------------------- ---------------- ---------------- ---------------- ----------------
VARCHAR2 7,805,484 202 0 0
CHAR 1,573 0 0 0
LONG 220,073 0 0 0
CLOB 91,227 15,718 0 0
VARRAY 23,479 0 0 0
--------------------- ---------------- ---------------- ---------------- ----------------
Total 8,141,836 15,920 0 0
Total in percentage 99.805% 0.195% 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 68,382,337 350,836 39 84
CHAR 322,930 0 0 0
LONG 0 0 0 0
CLOB 32,522 13,257 0 0
VARRAY 1,552 0 0 0
--------------------- ---------------- ---------------- ---------------- ----------------
Total 68,739,341 364,093 39 84
Total in percentage 99.473% 0.527% 0.000% 0.000%


I think it should be fine.
Please let me know.

thanks

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points