1.123 ENCRYPT_NEW_TABLESPACES
ENCRYPT_NEW_TABLESPACES
specifies whether to encrypt newly created user tablespaces.
Property | Description |
---|---|
Parameter type |
String |
Syntax |
|
Default value |
|
Modifiable |
|
Modifiable in a PDB |
Yes |
Basic |
No |
Oracle RAC |
The same value should be specified for all instances. |
The values that can be specified for the ENCRYPT_NEW_TABLESPACES
parameter have the following meanings:
-
CLOUD_ONLY
:When a user tablespace is created in the Oracle Cloud, it is transparently encrypted with Advanced Encryption Standard 128 (AES 128) if the
ENCRYPTION
…ENCRYPT
clause for the SQLCREATE
TABLESPACE
statement is not specified. When a user tablespace is created in an on-premises database, theENCRYPTION
clause of theCREATE
TABLESPACE
statement determines if the tablespace is encrypted.CLOUD_ONLY
is the default value. -
ALWAYS
:Whether the user tablespace is created in the Oracle Cloud or in an on-premises database, the tablespace will be transparently encrypted with AES128 if the
ENCRYPTION
…ENCRYPT
clause is not specified in theCREATE
TABLESPACE
statement. -
DDL
:Whether the user tablespace is created in the Oracle Cloud or in an on-premises database, the
CREATE
TABLESPACE
statement will follow the specified DDL. If noENCRYPTION
clause is specified, then the tablespace will not be encrypted. If theENCRYPTION
USING
…ENCRYPT
clause is specified, then the specified algorithm will be used to encrypt the tablespace. IfENCRYPTION
ENCRYPT
is specified, but no algorithm is specified, then the tablespace will be encrypted with the default AES128 algorithm.
See Also:
-
Oracle Database Advanced Security Guide for more information about tablespace encryption
-
Oracle Database SQL Language Reference for more information about the
CREATE
TABLESPACE
statement