Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Problems importing data from Oracle to MSSQL Server 2000 using a DTS package Expand / Collapse
Author
Message
Posted Friday, March 20, 2009 11:46 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Friday, November 7, 2014 11:03 AM
Points: 1, Visits: 11
Hi guys,
This is my scenario.. I need to synchronize data from oracle server to MSSQL Server 2000, for this purpose I'm using a DTS package (The connection is trough a ODBC Driver), the development was made using a TEST Oracle Server, so that never had this issue (There Wasn't limits for the resources), now, when i ran the DTS package over a real Production Oracle Server, a DTS DataPump Task failed (this task synchronize a table with 2,330,000 registry or more), the error code is ORA-01555, so I asked to a Oracle Administrator and the problem was originated because a concurrent use of the ROLLBACK SEGMENT (so the problem is that could not have a consistent reading), I need to know if exists something in the design of my DTS package thats could help me to solve this issue, i do not know if it is possible to establish a commit point for a determined quantity of information imported, making possible that the readings release the ROLLBACK SEGMENT and start again.

Any help will be too appreciated
Regards,
Jesus
Post #680613
Posted Tuesday, April 7, 2009 10:39 AM


SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Monday, October 25, 2010 6:09 AM
Points: 1,621, Visits: 409
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.




Thanks -- Vijaya Kadiyala
www.dotnetvj.com
SQL Server Articles For Beginers



Post #692285
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse