Page 1 of 1

Not Extracting data from Oracle

Posted: Mon Mar 12, 2012 7:57 am
by krisna
Hi All,

upto 2 days back the job was running (extracting data) from DB. But now it's not extracting and i don't see any progress. But when i executed that query in oracle client it shows the result. Please Advise.

Thanks in Advance.......

Posted: Mon Mar 12, 2012 8:01 am
by chulett
Ask your DBA to trace the process in the database, see what (if anything) that it is doing.

Posted: Mon Mar 12, 2012 7:42 pm
by qt_ky
Maybe the job aborted and Oracle session got hung preventing the job from running again.