Does Moving a Compressed Table to an Encrypted Tablespace Decompress and Re-compress the Table?
(Doc ID 1578154.1)
Last updated on OCTOBER 30, 2019
Applies to:Oracle Database - Enterprise Edition - Version 220.127.116.11 and later
Information in this document applies to any platform.
You have a table with basic compression that you want to move to a non-compressed, encrypted tablespace, and you want the table to remain compressed. You are using the following SQL to accomplish this:
You are wondering about the space needed to accomplish this. Will the table be uncompressed, encrypted, and then re-compressed?
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