Click here to monitor SSC
SQLServerCentral is supported by Redgate
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
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 28, 2014 9:39 AM
Points: 1, Visits: 12
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
Post #680613
Posted Tuesday, April 7, 2009 10:39 AM



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

Post #692285
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse