Re: help: DELETE with NOWAIT ?

Karen wrote:
>
> DELETE always hangs if the row is "taken". There is no NOWAIT option.
>
> But you can use SELECT FOR UPDATE with NOWAIT to lock the rows you are going
> to delete and then doing DELETE on them.
>
> Bill Weinberger wrote:
>
> > I know how to use NOWAIT to keep SELECT...FOR UPDATE from blocking on
> > Resource busy. But, how can I accomplish the same thing when I am deleting
> > rows, too?
> >
> > Thanks for your help.
> > Bill

I've never tried it (and not that I'd recommend it) - but possibly you could have a loopback database link, and rely on distributed timeout ???

CHeers

-- 
===========================================
Connor McDonald
http://www.oracledba.co.uk (mirrored at
http://www.oradba.freeserve.co.uk)

"Early to bed and early to rise, 
 makes a man healthy, wealthy and wise." - some dead guy