Forum Stats

  • 3,851,951 Users
  • 2,264,054 Discussions
  • 7,904,915 Comments

Discussions

Oracle compress implementation

797476
797476 Member Posts: 2
edited Oct 7, 2010 7:31PM in Advanced Compression
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

Answers

This discussion has been closed.