Re: Oracle Table Compression.

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_at_yahoo.com> 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_at_gmail.com> 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.
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>
>
> --
> http://www.freelists.org/webpage/oracle-l
>

--
http://www.freelists.org/webpage/oracle-l