Re: When ORA-00054 and when wait?

From: Jaap W. van Dijk <j.w.vandijk_at_hetnet.nl>
Date: Wed, 20 Feb 2002 09:07:30 GMT
Message-ID: <3c7365eb.569138@news.freeler.nl>

To add my own 2c: I've seen an ALTER TABLESPACE waiting, but if this is always the case...?

As I expected, opinions differ. Is there anyone with the definitive answer, and again: where is this documented?

Jaap.

On Tue, 19 Feb 2002 18:11:47 GMT, j.w.vandijk_at_hetnet.nl (Jaap W. van Dijk) wrote:

>When a required lock is already taken, which DML or DDL statement will
>result in a ORA-00054 (resource busy...) and which will result in a
>wait until the lock is freed?
>
>And where is this documented?
>
>Jaap.
Received on Wed Feb 20 2002 - 03:07:30 CST