This discussion is archived
1 Reply Latest reply: Oct 20, 2011 7:21 AM by Srini Chavali-Oracle RSS

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

sachinpawan Newbie
Currently Being Moderated
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

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points