Data Dictionary Views for Encrypted Data
Oracle Database provides data dictionary views to find information about encrypted data. See the following table for more information about the data dictionary views.
| View | Description |
|---|---|
ALL_ENCRYPTED_COLUMNS |
Describes encryption algorithm information for all encrypted columns in all tables accessible to the user |
DBA_ENCRYPTED_COLUMNS |
Describes encryption algorithm information for all encrypted columns in the database |
USER_ENCRYPTED_COLUMNS |
Describes encryption algorithm information for all encrypted columns in all tables in the schema of the user |
V$ENCRYPTED_TABLESPACES |
Displays information about the current pluggable database (PDB) tablespaces that are encrypted |
V$ENCRYPTION_WALLET |
Displays information on the status of the wallet and the wallet location for Transparent Data Encryption; applies to the current PDB only |
V$RMAN_ENCRYPTION_ALGORITHMS |
Displays supported encryption algorithms for the current PDB |