Re: Quick Question as I can't find the answer (Advanced Compression)
Date: Tue, 15 May 2018 17:27:36 +0300
Message-ID: <27fdedaf-6510-8626-fc14-c6726b29d837_at_gmail.com>
Hello.
use one of (to not trigger ACO usage):
create the same indexes. troubles with GLOBAL....
do EXCHANGE PARTITION
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."
> https://blogs.oracle.com/dbstorage/online-move-partition-to-any-compressed-format-a-lesser-known-feature-of-advanced-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.
>
> Chris
>
-- http://www.freelists.org/webpage/oracle-lReceived on Tue May 15 2018 - 16:27:36 CEST