Re: strang table locking
From: Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk>
Date: Mon, 29 Jan 2001 20:24:51 -0000
Message-ID: <980799872.2896.0.nnrp-14.9e984b29_at_news.demon.co.uk>
Date: Mon, 29 Jan 2001 20:24:51 -0000
Message-ID: <980799872.2896.0.nnrp-14.9e984b29_at_news.demon.co.uk>
Good point.
[Quoted] You can (at least on 8.1.7, which is what my HP is at present):
alter table xxx initrans 4;
alter table move;
or
alter table xxx move initrans 4;
and the ini_trans column of the resulting table
is indeed 4 - and it should be true, although I
haven't actually tried packing a sample table
and dumping the resulting blocks after the move.
-- Jonathan Lewis Yet another Oracle-related web site: http://www.jlcomp.demon.co.uk Practical Oracle 8i: Building Efficient Databases Publishers: Addison-Wesley More reviews at: http://www.jlcomp.demon.co.uk/book_rev.html Howard J. Rogers wrote in message <3a755c8a_at_news.iprimus.com.au>...Received on Mon Jan 29 2001 - 21:24:51 CET
>Jonathan: If inittrans is changed (it's only part of the sotrage clause
>after all), will a move tablespace command result in the entire segment
>picking up the new value?
>
>Regards
>HJR
>