Re: truncate randomly failing

Erika wrote:
> Matthias : You are asking: what can go wrong in a truncate? Thats
> exactly my question. But something does (so we just added this loop to
> see if we can truncate if we try 100-times).
> But lets forget about the loop for a moment. The error I am getting is

no.
please use my procedure and tell us if this works. (if not, tell us ORA-Errornumber)
it could be the loop is the problem.

> not the lock error (ORA-00054), but ORA-00942: table or view does not
> exist. So I don't see why would locking the table in the code make any
> difference. It really looks more like a permission problem, except

in fact, you have used the loop in order to avoid ORA-00054, true ? (if not, tell us please, what the hell the loop is for ....)

> that the same user can sometimes truncate the table and sometimes he
> can't. And this happens for different users and about 10 different
> tables. That's why the problem is such a mystery to me.

if it were a permission problem, someone would revoke permissions (and probably someone would re-grant them) ask your dba to audit grant's and revoke's

Matthias Received on Tue Dec 10 2002 - 09:04:13 CST