Home Forums SQL Server 7,2000 Working with Oracle Problems importing data from Oracle to MSSQL Server 2000 using a DTS package RE: Problems importing data from Oracle to MSSQL Server 2000 using a DTS package
Vijaya Kadiyala
SSCrazy Eights
Points: 9119
More actions
April 7, 2009 at 10:39 am
#973607
Hi
Ask your Oracle DBA to increase RollBack Segment size. In addition to this instead of reading all the records at one shot read them in chunks to avoid any kind of erros on source side.