Re: Truncate

[David Donnelly <Dave@ISISBIO.COM>]

Crystal,

This isn't an SQR error.  Some other process has the table locked, and you
can't truncate a table with locks on it.  This is a problem for your system
administrator or DBA.

To back up a little, do you want to tell us why you're trying to free
storage this way? Is it necessary, or do you just need to delete all rows
and want to bypass rollback?  I've had to delete rows from a big table 5000
at a time to avoid the rollback failure problem.  Another idea, of course,
is just to drop and recreate the table, but you won't be able to do that if
it's locked either.

HTH

Dave

At 10:29 AM 8/27/1998 -0500, you wrote:
>I am still not able to get truncate to work is it because the version we
>are using (V3.0.6.1) is too old?
>I have tried this with and without the reuse storage option.

>(SQR 5528) ORACLE OPARSE error -54 in cursor 12:
>   ORA-00054: resource busy and acquire with NOWAIT specified
>SQL:  truncate table ps_dist_ln
>Error at:  ps_dist_ln
>