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!

Decimal of SQL Server getting converted to Whole number in ORACLE

604466Oct 27 2007 — edited Nov 2 2007

Hi All,
I am using ORACLESQL Developer tool to migrate database from SQL Server to ORACLE. The decimal datatype in Sql Server is not getting converted to its equivalent in ORACLE. Do anyone face the same problem? Its getting converted to WHOLE number.

Also I am able to import data only from Excel sheet. Is therre any other option to import data using this tool?

Also is the tool the best to use for migration? Please give me your suggestions pls since I am facing this conversion problem after import lakhs of data.

I am using version 1.1.3

Thanks in Advance,
Srinivasan.T

Locked Post

New comments cannot be posted to this locked post.

Locked on Nov 30 2007

Added on Oct 27 2007

#sql-developer

2 comments

1,537 views