Does Moving a Compressed Table to an Encrypted Tablespace Decompress and Re-compress the Table? (Doc ID 1578154.1)

Last updated on MARCH 27, 2014

Applies to:

Oracle Database - Enterprise Edition - Version 11.2.0.3 and later
Information in this document applies to any platform.

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

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms