1 Reply Latest reply: Jun 30, 2011 3:16 AM by "Gunther Vermeir, Oracle-Oracle" RSS

    Can I use DMU for this database?

    Jcgo-Oracle
      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