Purpose
This statement is used to modify the attributes of a tablespace.
Syntax
ALTER TABLESPACE tablespace_name
[ ENCRYPTION USING 'algorithm' ]
algorithm:
'AES-256' | 'AES-128' | 'AES-192' | 'SM4-CBC'
Parameters
| Parameter | Description |
|---|---|
| tablespace_name | The name of the tablespace to be modified. |
| algorithm | The name of the encryption algorithm. Valid values: 'AES-256', 'AES-128', 'AES-192', and 'SM4-CBC'. |
Examples
-- Create a tablespace named users.
obclient> CREATE TABLESPACE users;
-- Modify the encryption algorithm of the users tablespace.
obclient> ALTER TABLESPACE users ENCRYPTION USING 'AES-256';