RE: Oracle Table Compression.
- From: Mirza Shahed <Shahed.Mirza@xxxxxxxxx>
- To: "'oracle-l@xxxxxxxxxxxxx'" <oracle-l@xxxxxxxxxxxxx>
- Date: Tue, 21 Sep 2004 09:41:52 +0100
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@xxxxxxxxx [mailto:desert_moon@xxxxxxxxx]
Sent: 20 September 2004 18:53
To: Shahed.Mirza@xxxxxxxxx
Cc: 'oracle-l@xxxxxxxxxxxxx'
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@xxxxxxxxx>:
> 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.
> ************************************************************************
>
>
>
> --
> //www.freelists.org/webpage/oracle-l
>
--
//www.freelists.org/webpage/oracle-l
Other related posts:
