Home » Infrastructure » Other Operating Systems » Capturng Oracle errors created during direct load SQL*LDR
Capturng Oracle errors created during direct load SQL*LDR [message #113610] Tue, 23 January 2001 03:31
Loren Bradford
Messages: 19
Registered: January 2001
Junior Member
We have had some problems while performing direct loads to table with indexes. At the end of the process loading the table; SQL*LDR rebuilds the indexes and constraints. We sometime get ORA-01658 errors, while creating the index/constraint, and the job step returns a zero return code and puts the offending index/constraint in direct load state. The state of the index/constraint is not found until later jobs are run and they fail due to direct load state problem. Is there a way to capture these ORACLE errors and force a non-zero return code?

Thanks

Loren
Previous Topic: ora-1012
Next Topic: AM4CICS stub
Goto Forum:
  


Current Time: Thu Nov 27 10:38:29 CST 2014

Total time taken to generate the page: 0.14820 seconds