Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 Data Corruption Issues
 over flow error

Author  Topic 

aakcse
Aged Yak Warrior

570 Posts

Posted - 2009-05-04 : 05:52:56
Hello All,
I am migrating data from Oracle to sqlserver using MS tool called Sql Migration Assistance for Oracle.

I have migrated most of the tables, however for some tables I am getting error oci - 22053 over flow error.

Can any one help me with this error, I have understanding that rounding may help, but I dont want to loose any data
while migration.


Regards,
aak

senthil_nagore
Master Smack Fu Yak Hacker

1007 Posts

Posted - 2009-05-04 : 06:38:07
Mark those table and try to migrate using SQL Server DTS technique.


Senthil.C
------------------------------------------------------
[Microsoft][ODBC SQL Server Driver]Operation canceled
Go to Top of Page

aakcse
Aged Yak Warrior

570 Posts

Posted - 2009-05-04 : 06:43:21
However through DTS I am not able to display Japanese char, hence using this Tool, coz after migrating I am able to
Japanese data set using only this tool.

DTS works perfect, japanes char is displayed as inverted question mark.
Regards,
Aak
Go to Top of Page
   

- Advertisement -