-
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!
-
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
-
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.
-
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"
-
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)
--- Everything was meant to be---
-
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
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|