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.