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

  • From: Tim Gorman <tim.evdbt@xxxxxxxxx>
  • To: oracle-l@xxxxxxxxxxxxx
  • Date: Tue, 15 May 2018 08:34:35 -0600

Everything other than BASIC is licensed, one way or the other. The MOVE ONLINE caveat mentioned here is subtle, but not surprising.  If you refer to the Oracle10g docs instead of the current ones, you should be OK.  All of the cost-bearing partitioning features (beyond the partition option itself) were added from Oracle11g v11.1.x and above...

On 5/15/18 07:48, Chris Taylor wrote:

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: