DBAsupport.com Forums - Powered by vBulletin
Results 1 to 6 of 6

Thread: DTS is not catching Oracle errors

  1. #1
    Join Date
    Oct 2005
    Posts
    3

    DTS is not catching Oracle errors

    Hi, All!!

    I work with Microsoft DTS and I load one table from Oracle with DTS using "select * .." without "where" caluse to MS SQL 2000 server.
    My problem is that sometimes when the DTS has finished successfully, the data is not loaded wholly and I see in the Oracle logs "ORA-01555 snapshot too old: rollback segment number string with name "string" too small ".
    Is there any way I can catch this error through the DTS? (in order to reload the table).
    Please, help!

  2. #2
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,334
    sounds like a Micorosft problem, not an oracle problem. Asked in any microsoft forums.

    But sort your queries and rollback segments out in oracle - they arent doing very well

  3. #3
    Join Date
    Oct 2005
    Posts
    3
    Quote Originally Posted by davey23uk
    sounds like a Micorosft problem, not an oracle problem. Asked in any microsoft forums.

    But sort your queries and rollback segments out in oracle - they arent doing very well
    Yes, I know it is a MS problem. But I hoped if someone had that sort of problem to help me.

  4. #4
    Join Date
    Feb 2000
    Location
    Singapore
    Posts
    1,758
    Have you tried enabling logging for the DTS package? It might give you some error.
    Sanjay G.
    Oracle Certified Professional 8i, 9i.

    "The degree of normality in a database is inversely proportional to that of its DBA"

  5. #5
    Join Date
    Jan 2002
    Location
    Netherlands
    Posts
    1,587

    try loading data first in..

    a temp table and then push it towards Oracle.

    How many rows are we talking about BTW?
    Tarry Singh
    I'm a JOLE(JavaOracleLinuxEnthusiast)
    TarryBlogging
    --- Everything was meant to be---

  6. #6
    Join Date
    Oct 2005
    Posts
    3
    The DTS logging is enabled already.

    And to answer Tarry - the table is about 13 000 000 rows.

    But it fails very rare - in 1-2% of the cases, but for me this is problem..

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width