Re: truncate table

From: Matthias Hoys <idmwarpzone_NOSPAM__at_yahoo.com>
Date: Wed, 25 May 2005 22:51:32 +0200
Message-ID: <4294e554$0$26070$ba620e4c@news.skynet.be>

<Bullseye> wrote in message
news:efo991dss2qh10tlfeanurdpjulhomsif8_at_4ax.com...
> Hi!
>
> I have a problem - Can anyone help?
>
> I have a requirement to lock a table (to deny all write access to it),
> update records in another table, and then to truncate the "locked"
> table before allowing access to it.
>
> The problem is that the truncate table issues a commit (which is fine)
> but the commit releases my lock and allows queued transactions to
> commit BEFORE actionning the truncate (Of it seems to!).
>
> How can I ensure that the truncate table is executed before any other
> transactions are committed bu other processes?
>
> TIA
SELECT ... FROM ... FOR UPDATE locks the entire table.

HTH
Matthias Received on Wed May 25 2005 - 15:51:32 CDT