Win a copy of Think Java: How to Think Like a Computer Scientist this week in the Java in General forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

database can not be accessed -- Please help !

 
lily zou
Ranch Hand
Posts: 50
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
 
Peter den Haan
author
Ranch Hand
Posts: 3252
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic