How to Set Compression for Future Table Partitions
(Doc ID 1984916.1)
Last updated on OCTOBER 25, 2019
Applies to:
Oracle Database - Enterprise Edition - Version 11.1.0.7 and laterOracle Database Cloud Schema Service - Version N/A and later
Oracle Database Exadata Express Cloud Service - Version N/A and later
Oracle Database Exadata Cloud Machine - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Information in this document applies to any platform.
Goal
Use this note to see how to add compression to a partitioned table such that future partitions will be compressed. This note uses an interval-partitioned table as the example, but this applies to any type of table compression with a partitioned table, including basic compression.
Solution
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
| Goal |
| Solution |
| 1. Specify table-level compression in the CREATE TABLE statement |
| 2. Alter the default attributes of the table after the table has been created (affects future partitions only) |
| References |