Re: Changing initrans
Date: Wed, 20 Aug 2008 19:00:26 -0700
Initrans is applicable only to future blocks. To prove: Do a simple block dump (search for alter system dump) and verify before and after the changes.
On Wed, Aug 20, 2008 at 5:26 PM, <richa03_at_gmail.com> wrote:
> If I rebuild an index online changing the initrans parameter, does it
> change initrans for all blocks of the index or just future blocks?
> Is there a method by which I can prove this?
-- Best Regards, K Gopalakrishnan Co-Author: Oracle Wait Interface, Oracle Press 2004 http://www.amazon.com/exec/obidos/tg/detail/-/007222729X/ Author: Oracle Database 10g RAC Handbook, Oracle Press 2006 http://www.amazon.com/gp/product/007146509X/ -- http://www.freelists.org/webpage/oracle-lReceived on Wed Aug 20 2008 - 21:00:26 CDT