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:

Goal

Question:

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?
 

Solution

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.