| Author |
database can not be accessed -- Please help !
|
lily zou
Ranch Hand
Joined: Jan 15, 2002
Posts: 50
|
|
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
Joined: Apr 20, 2000
Posts: 3252
|
|
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
|
 |
 |
|
|
subject: database can not be accessed -- Please help !
|
|
|