Re: Oracle Table Compression.

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