23.6 Testing the Encryption

Test the encryption by checking if a tablespace is encrypted or not. Execute the following query to check:

SELECT tablespace_name, encrypted FROM dba_tablespaces;

The following result is displayed, which indicates whether the TABLESPACE is encrypted (ENCRYPTED TS - YES) or not (ENCRYPTED TS - NO) in the ENCRYPTED column:

TABLESPACE_NAME ENCRYPTED
------------------------------ ---
SYSTEM                       NO
SYSAUX                       NO
UNDOTBS1                     NO
TEMP                         NO
USERS                        NO
ENCRYPTED_TS                 YES

6 rows selected.

The above example indicates TABLESPACE ENCRYPTED_TS is created with Encryption ON.