Re: locks on objects that are modified (DDL) ..

From: Tanel Poder <change_to_my_first_name_at_integrid.info>
Date: Wed, 24 Sep 2003 12:00:41 +0300
Message-ID: <3f715d3b_1@news.estpak.ee>

Just issue the DDL and query for the locks from v$lock. If your table is too small and the locks disappear too fast when operation completes, then use tablespaces with very limited free storage plus "alter session enable resumable". That way if your operation runs out of space, it will just wait there and you can study the locks as much as you like.

However, there might be different locks acquired during different phases of an operation (online index rebuild for example).

Tanel.

"Daniel" <danielsalzer_at_yahoo.com> wrote in message news:399b48fb.0309231641.234af123_at_posting.google.com...
> Hello,
>
> what kind of lock does the Oracle RDBMS put on a table if:
> - a column is added, altered
> - an index is added or altered
>
> Thanks
> D
Received on Wed Sep 24 2003 - 04:00:41 CDT