Skip to Main Content
Forums

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Oracle compress implementation

797476Sep 16 2010 — edited Oct 7 2010
Hello
does anyone try the following compression solution based on Oracle standard compression
1) partitioning of the table which must be compressed
2) The partition are based on the month (m)
3) creating a new tablespace with compress option turn on
4) at (m +1), move partition (m) to the compressed tablespace
5) Delete Partition (m) from its original tablespace

regarads

Comments

damorgan
You can compress or not compress at the partition level. I am unclear as to the point of your inquiry.
1 - 1
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Nov 4 2010
Added on Sep 16 2010
#advanced-compression, #data-warehousing
1 comment
1,812 views