Re: Oracle Table Compression.
- From: rjamya <rjamya@xxxxxxxxx>
- To: shahed.mirza@xxxxxxxxx
- Date: Tue, 21 Sep 2004 07:09:54 -0400
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@xxxxxxxxx> 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
Other related posts:
