Re: Changing initrans

From: "K Gopalakrishnan" <kaygopal@xxxxxxxxx>
To: richa03@xxxxxxxxx
Date: Wed, 20 Aug 2008 19:00:26 -0700

Rich,

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.


-Gopal


On Wed, Aug 20, 2008 at 5:26 PM,  <richa03@xxxxxxxxx> 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?
>
> TIA,
> Rich
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>



-- 
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-l

Follow-Ups:

RE: Changing initrans
From: Mark W. Farnham

References:
- Changing initrans
  - From: richa03

Re: Changing initrans

Other related posts: