Problems importing data from Oracle to MSSQL Server 2000 using a DTS package

  • 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

  • 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.

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply