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