Oracle View to Text File
Posted: Thu Oct 13, 2005 8:41 pm
Hi, Thank you for all the supports so far.
I run a job to read from Oracle View and Extract to a Text File.
At the time I was running the Job, I have been experiencing a lot of Jobs getting "Abnormal Termination".
Anyway, I got a successful flag for this job, but it turns out it writes less rows than expected.
After that, we reboot the server to claim whatever resources unclaim and it runs Just Fine. (we did a few times issue UNLOCK ALL command using TELNET).
I checked the Oracle Log and Application Log and there's nothing indicates this problem.
Any pointers what caused this problem or what are the usual suspects?
Thanks
I run a job to read from Oracle View and Extract to a Text File.
At the time I was running the Job, I have been experiencing a lot of Jobs getting "Abnormal Termination".
Anyway, I got a successful flag for this job, but it turns out it writes less rows than expected.
After that, we reboot the server to claim whatever resources unclaim and it runs Just Fine. (we did a few times issue UNLOCK ALL command using TELNET).
I checked the Oracle Log and Application Log and there's nothing indicates this problem.
Any pointers what caused this problem or what are the usual suspects?
Thanks