Oracle write hangs infinitely
Moderators: chulett, rschirm, roy
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.