Not Extracting data from Oracle

krisna · Post by **krisna** » Mon Mar 12, 2012 7:57 am

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.......

chulett · Post by **chulett** » Mon Mar 12, 2012 8:01 am

Ask your DBA to trace the process in the database, see what (if anything) that it is doing.

qt_ky · Post by **qt_ky** » Mon Mar 12, 2012 7:42 pm

Maybe the job aborted and Oracle session got hung preventing the job from running again.