My Oracle Support Banner

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

Last updated on NOVEMBER 07, 2023

Applies to:

Oracle Database - Enterprise Edition - Version 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

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