Re: Truncate

[Kenny Melton <KMELTO1@TANDY.COM>]

Is it possible that the table is being accessed at the same time you are
trying to truncate it?  Are you accessing the table within the sqr for
insert, update, or delete?  If so, try performing a "commit" before the
truncate to release any locks your sqr may have on the table.  Hope this
helps...

Kenny Melton
Tandy Information Services
kmelto1@tandy.com

> -----Original Message-----
> From: Thompson,Crystal [SMTP:THOMPSCD@AGEDWARDS.COM]
> Sent: Thursday, August 27, 1998 10:29 AM
> To:   Multiple recipients of list SQR-USERS
> Subject:      Truncate
>
> 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.
>
>
> SQRW: Structured Query Report Writer V3.0.6.1
> Copyright (C) MITI, 1994, 1995.  All Worldwide Rights Reserved.
>
> (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
>
> Error on line 179:
>    (SQR 3716) Error in SQL statement.
>
>
> Errors were found in the program file.
>
> SQRW: Program Aborting.