Fuad, 9.2.0.6? I've seen specific components with that version listed, but heard nothing yet as to it being released as a comprehensive OUI-driven patchset. Any idea as to when this will be released? thanks, Paul On Tue, 21 Sep 2004 06:32:23 -0700 (PDT), Fuad Arshad <fuadar@xxxxxxxxx> wrote: > Oracle does have a one off patch for the bug in which you cannot alter a > table after compressing it and its not included in 9.2.0.5 not will it be > included in 9.2.0.6 seperate one offs need to be backported to each patch > set. > the bug number is 2421054 > > > > rjamya <rjamya@xxxxxxxxx> wrote: > you can compress tables, and associated indexes as well. Remember that > in some versions of 92xx, you can't do direct exports, they throw > ora-600. also you cannot alter columns using ddl when compressed, so > you need to be able to un-compress if table needs to be altered. > > Otherwise it may be a good thing, as always all expressed opinions are > invalid without you doing tests to satisfy your needs in your > environment. > > Raj > > On Tue, 21 Sep 2004 09:41:52 +0100, Mirza Shahed wrote: > > Thank you everyone, > > > > What I am really looking for problems and solutions normally identified and > > resolved with table compression. > > > > I have read about this, I have also tried on our development database. > > > > I have noticed that secondary index goes un-usable when I compress a table. > > Does this means I have to compress secondary index as well, or should I drop > > secondary index as it is not required anymore? > > > > TIA, > > Shahed. > -- > //www.freelists.org/webpage/oracle-l > > > > > -- > //www.freelists.org/webpage/oracle-l > -- //www.freelists.org/webpage/oracle-l