1 Reply Latest reply: Oct 20, 2011 9:21 AM by Srini Chavali-Oracle RSS

    compression of pre-exist data of tables using Adv. compression tech of 11g

    sachinpawan
      i compressed 65 tables(660gb) by using alter table tab_name move compress.....now the size of the tables reduced to 590gb only, already this feauture was there in 10g.......
      but by using advanced compression of 11g we can compress upto 220-250gb.....
      so how can i use advance compression of 11g in this regard....

      (OR)

      i have one table(20gb) , i want to compress this table by using advance compression technology of 11g
      size should reduced to 6-9 gb.... how can i achieve this....
      plz...........

      Edited by: user10268498 on Oct 20, 2011 9:19 AM