Start Free TrialLog in
Avatar of vijay1507
vijay1507

asked on 

Date Transfer through Sql server migration assistant

Hi ,

I am getting the Error OCI-22053: overflow error while trying to transfer data from Oracle to Sql server by using  Sql server management assistant  
This happens after 80k rows  which is 24% of the total volume
can someone help me out !!!!!!
Oracle DatabaseMicrosoft SQL Server 2008Microsoft SQL Server 2005
Avatar of undefined
Last Comment
vijay1507
Avatar of tigin44
tigin44
Flag of Türkiye image
When Fill uses OracleDataReader.GetValues, numeric values are converted from
OracleNumber to System.Decimal which has a smaller range and the risk of
overflow.  In V1.1 there is no workaround other than to not use Fill and
directly call OracleDataReader.GetOracleValues.

In .Net Framework V2.0, there is a new property on OracleDataAdapter called
ReturnProviderSpecificTypes in which the adapter will create the DataColumn
with OracleNumber instead of System.Decimal.

you can overcome this by using the ROUND() to decrease the precision of your oracle number field in your source query.
 also take a look at this link

http://social.msdn.microsoft.com/forums/en-US/adodotnetdataproviders/thread/4032e2fe-9f37-47d8-9af6-35f1675e9d84/
Avatar of vijay1507
vijay1507

ASKER

HI  
can I use ant setting in SSMA to over come this mine is sql server migration Assistant for oracle 4.0.1402

ASKER CERTIFIED SOLUTION
Avatar of tigin44
tigin44
Flag of Türkiye image
Blurred text
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
Avatar of vijay1507
vijay1507

ASKER

this issue was solved thatnks  for the help
Oracle Database
Oracle Database

Oracle is an object-relational database management system. It supports a large number of languages and application development frameworks. Its primary languages are SQL, PL/SQL and Java, but it also includes support for C and C++. Oracle also has its own enterprise modules and application server software.

81K
Questions
--
Followers
--
Top Experts
Get a personalized solution from industry experts
Ask the experts

  • "Invaluable tool for our organization"

    Josh Regalski

  • "Your help has saved me hundreds of hours of internet surfing."

    @fblack61

  • "Just a dang good service!"

    @golferski

  • "Worth every penny."

    Steve Hougom

  • "It’s been a life saver."

    Maria Halt

  • "Best support site I’ve seen!"

    Bob Schneider

  • "I would be lost without them."

    @fblack61

  • "Saved my job multiple times."

    Walt Forbes

  • "I love this site."

    Maria Duwe

  • "Friendly respectful help."

    Andrew Kowtalo

  • "Such top-notch experts."

    @magento

  • "The best money I have ever spent."

    @rwheeler23

  • "Beyond any comprehensible value"

    George Morris

  • "Invaluable tool for our organization"

    Josh Regalski

Read over 600 more reviews

TRUSTED BY

IBM logoIntel logoMicrosoft logoUbisoft logoSAP logo
Qualcomm logoCitrix Systems logoWorkday logoErnst & Young logo
High performer badgeUsers love us badge
LinkedIn logoFacebook logoX logoInstagram logoTikTok logoYouTube logo
© 1996-2023 Experts Exchange, LLC. All rights reserved. Covered by US Patent