This week's book giveaway is in the OCAJP 8 forum. We're giving away four copies of OCA Java SE 8 Programmer I Study Guide and have Edward Finegan & Robert Liguori on-line! See this thread for details.
Hi, there I encountered a quite strang problem with my table in oracle. I have a process to write to a database all the time. And also I have a cron process to read from this table once a day at 00:11:00. But every midnight around 00:01:40, first process starts to throw me exception saying can't update the table and repeats this message untill cron job starts. Therefore I lost all the data sent in between. After that every thing is normal but next day the same thing happens again. I am wondering what is the most likely cause to block a table to be accessed or updated ? Any advice is highly appreciated . Lily
Surely the exception that's being thrown has more information? In any case, I would suspect some type of overnight database maintenance -- the database taken offline or even rebooted to do a backup or somesuch. Talk to your DBA. - Peter