7.17.2.2 Test 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 or not in the ENCRYPTED column.
Table 7-4 Testing the Encryption
| TABLESPACE_NAME | ENCRYPTED |
|---|---|
| SYSTEM | NO |
| SYSAUX | NO |
| UNDOTBS1 | NO |
| TEMP | NO |
| USERS | NO |
| ENCRYPTED_TS | YES |
The above example indicates TABLESPACE ENCRYPTED_TS is
created with Encryption ON.