Re: strang table locking

Good point.
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>...


>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

>