6 Replies Latest reply on Jun 26, 2012 9:39 AM by 930168

    advaced compression in oracle 11g


      We are migrating databases from oracel 10g to 11g and we are using advance compression, i have few question please help me to understand

      1. if i enable compression on tables is index also get compressed if not how i can enable compression on indexes

      2.For table compression i will take the DDL of tables from oracle 10g databases and i create the tables in oracle 11g with COMPRESS FOR ALL OPERATIONS is this the right approach

      Appreciated the inputs