RE: Oracle Table Compression.

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.

-----Original Message-----
From: desert_moon_at_online.ie [mailto:desert_moon_at_online.ie] Sent: 20 September 2004 18:53
To: Shahed.Mirza_at_aah.co.uk
Cc: 'oracle-l_at_freelists.org'
Subject: Re: Oracle Table Compression.

Nice feature for DW applications and HISTORICAL Partitioned Tables where in U
can compress individual partition.

Oracle technet has a good article on this from Sanjay Mishra

http://www.oracle.com/technology/oramag/oracle/04-mar/o24tech_data.html

> Need to verify its benefits before putting into production

HTHU Ankur Shah
Oracle DBA
DHR-GA Quoting Mirza Shahed <Shahed.Mirza_at_aah.co.uk>:

> Hi Gurus,
> Does anyone here have used Oracle table compression?
>
> I would like to know pros and cons of this functionality.
>
> Cheers,
> Shahed.
>
>
>
>
> ************************************************************************
> DISCLAIMER
> The information contained in this e-mail is confidential and is intended
> for the recipient only.
> If you have received it in error, please notify us immediately by reply
> e-mail and then delete it from your system. Please do not copy it or
> use it for any other purposes, or disclose the content of the e-mail
> to any other person or store or copy the information in any medium.
> The views contained in this e-mail are those of the author and not
> necessarily those of Admenta UK Group.
> ************************************************************************
>
>
>
> --
> http://www.freelists.org/webpage/oracle-l
>

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