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

Hi.

use 2) without EXCHANGE PARTITION part wrapped up into DBMS_REDEFINITION

Best Regards,

     Oleksandr Denysenko

15.05.2018 17:30, Chris Taylor ïèøåò:
> Ah - I missed that part about it being specific to ONLINE operations.
>
> Thanks,
> Chris
>
>
> On Tue, May 15, 2018 at 9:27 AM, Oleksandr Denysenko <odenysenko_at_gmail.com
> <mailto:odenysenko_at_gmail.com>> wrote:
>
> Hello.
>
> 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....
>
> 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
>> <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-l