Re: Quick Question as I can't find the answer (Advanced Compression)

  • From: Oleksandr Denysenko <odenysenko@xxxxxxxxx>
  • To: christopherdtaylor1994@xxxxxxxxx, ORACLE-L <oracle-l@xxxxxxxxxxxxx>
  • Date: Tue, 15 May 2018 17:27:36 +0300


use one of (to not trigger ACO usage):

1) move without ONLINE option - quite good for historical data

2) create new table with the same structure and compression enabled using CTAS

   create the same indexes. troubles with GLOBAL....


I prefer 2) because during this operation you may do RIGHT ORDER BY to place repeating values closer and increase compression ratio or increase indexes clustering factor.

Best Regards,

    Oleksandr Denysenko

15.05.2018 16:48, Chris Taylor пишет:

If we (DBAs) want to specify compression on a Partition/Subpartition, which options are specific to Advanced Compression and which are not?

For example, this link says:
" Certain uses of
Online Move Partition require Advanced Compression: specifically, if the
feature is used to move a partition or subpartition to a compressed format
including Basic, Advanced Row, or Hybrid Columnar Compression."

I'm trying to find a simple answer on how to get compression and avoid advanced compression gotchas as we're not licensed to use it.


Other related posts: