Re: Oracle Table Compression.

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 <shahed.mirza_at_aah.co.uk> 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