Oracle 8.0.5, HPUX. Sometimes while trying to do a simple "truncate
table table_name", we get the error ORA-00054: resource busy
and acquire with NOWAIT specified. We aren't using a NOWAIT
keyword and there isn't anybody else on the database. After
we get the error, we can't do the truncate without shutting down
the database. What can be done to prevent this random error
and what can be done so that after this error occurs, we can
still run truncate without having to shut down?
(Not sure but I think the developers may be killing a truncate
the first time around and this error may be occurring the second
time they try to run it.)
Sent using MailStart.com (
http://MailStart.Com/welcome.html )
The FREE way to access your mailbox via any web browser, anywhere!
Received on Mon Nov 27 2000 - 16:32:15 CST
