0 Replies Latest reply on Apr 28, 2016 6:00 AM by b52824f3-7c7a-448b-a1ac-8c7c1b191969

    Bug: Migration from mysql to oracle

    b52824f3-7c7a-448b-a1ac-8c7c1b191969

      Hello!

       

      When I do a migration task from  MySQL 5.1.73  to Oracle 11.2.0.1.0  by using Oracle SQL Developer 4.1.3.20 build Mian-20.78,

      SQL Developer sets the precision value of decimal in md_cloumns to 0. 

       

      When I check the precision values in all_col_data_tabsxxxx.txt , 

      the decimal type has the correct precision value.

       

      TX_SEQ_NBR  decimal(7,0)    NO      NULL

       

      But when I select the precision value  in md_columns,

      the value is 0.

       

      select column_name, column_type, precision

      from md_columns

      where column_name='TX_SEQ_NBR';

       

      The results are

      TX_SEQ_NBR  DECIMAL  0.