Oracle write hangs infinitely
Moderators: chulett, rschirm, roy
Excellent job of narrowing down the problem. So now you actually can get a data file and the SQL script and could reproduce the problem outside of DataStage so I would suggest you involve the DBA so that he or she can monitor what happens when you run it.
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
Thanks ArndW.
I can't see your suggestions after third line.
I set APT_ORA_WRITE_FILES =' (DIRECT=TRUE, PARALLEL=FALSE) '
Inspired by the success of Oraupsert , I tried Upsert on a table using a sort Stage whose Output is 918553 records. Now the same Porblem of hang is reproduced.
Does DS use sqllloader when the records cross a certain limit?
I can't see your suggestions after third line.
I set APT_ORA_WRITE_FILES =' (DIRECT=TRUE, PARALLEL=FALSE) '
Inspired by the success of Oraupsert , I tried Upsert on a table using a sort Stage whose Output is 918553 records. Now the same Porblem of hang is reproduced.
Does DS use sqllloader when the records cross a certain limit?
Two wrongs don't make a right. But three lefts do.
Thanks everybody for the Technical guidance.
The issue isn't resolved yet, but hope it soon due to diligence efforts by the members of this forum.
Although not complete resolution, but narrowing down the possibilty of cause gave me a good knowledge of the basics required.
Thanks Folks,
The issue isn't resolved yet, but hope it soon due to diligence efforts by the members of this forum.
Although not complete resolution, but narrowing down the possibilty of cause gave me a good knowledge of the basics required.
Thanks Folks,
Two wrongs don't make a right. But three lefts do.