E.g:
CREATE TABLESPACE securespace
DATAFILE ‘/u01/app/oracle/oradata/techdatabasket/secure01.dbf’ SIZE 100M
ENCRYPTION USING ‘AES256’
DEFAULT STORAGE(ENCRYPT);
VIEWS:
V$ENCRYPTED_TABLESPACE
DBA_TABLESPACES
USER_TABLESPACES
Database Administration -> Database Administrator’s Guide -> 13.2.5 Encrypted Tablespaces
Oracle Database Administrator’s Guide -> 20 Managing Tables -> 20.2.13 Consider Encrypting Columns That Contain Sensitive Data
Hi! I am Bruno, a Brazilian born and bred. Former Oracle ACE, Computer Scientist, MSc in Data Science, over ten years of experience in companies such as IBM, Epico Tech, and Playtech based in three different countries (Brazil, Hungary, and Sweden) and joined projects remotely in many others. I am super excited to show you my interest in Databases, Cloud, Data Science, Data Engineering, Bigdata, AI, Programming, Software Engineering, and data in general.
(Continue reading)