Skip to Main Content

SQL Developer

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Bug: Migration from mysql to oracle

b52824f3-7c7a-448b-a1ac-8c7c1b191969Apr 28 2016 — edited Apr 28 2016

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.

Comments

Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on May 26 2016
Added on Apr 28 2016
0 comments
362 views