Does Moving a Compressed Table to an Encrypted Tablespace Decompress and Re-compress the Table?
Last updated on MARCH 27, 2014
Applies to:Oracle Database - Enterprise Edition - Version 188.8.131.52 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?
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