Re: ALTER TABLE (schema migration)

From: Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk>
Date: Wed, 17 Nov 1999 21:51:14 -0000
Message-ID: <942876323.27312.0.nnrp-03.9e984b29@news.demon.co.uk>

It depends on the operation and on
the version of Oracle.

Under 8.1 the BNF diagrams for ALTER
table cover about 5 pages - some of the changes require a total exclusion lock for a very long time, some require a lock for one to three very brief intervals, some don't really require a lock at all.

Jonathan Lewis
Yet another Oracle-related web site: http://www.jlcomp.demon.co.uk

Paul Gladden wrote in message <80uqgq$mpp_at_nntpb.cb.lucent.com>...
>We're moving to Oracle and I cannot find any information
>relating to Oracle's locking hierarchy for an "alter table"
>or how Oracle's "alter table" is facilitated.
>
Received on Wed Nov 17 1999 - 15:51:14 CST