【kingsql分享】表空間加密

一個非常簡單的實驗，Oracle11G新特性
1.在sqlnet.ora中為encryption_wallet_location指定位置
sqlnet.ora寫入如下內容
encryption_wallet_location=(source=(method=file)(method_data=(directory=/u01/hzh11g/wallet)))

2.建立相應的目錄
mkdir -p /u01/hzh11g/wallet

3.建立錢包

> alter system set encryption key identified by "Hzh12345";

System altered.

4.建立加密表空間

> create tablespace enchzh1
  2  datafile '/u01/app/oracle/oradata/hzh11g/enchzh1.dbf' size 10M
  3  encryption using '3DES168'
  4  default storage (ENCRYPT);

Tablespace created.
//預設加密演算法是DES128，其他的有3DES168,AES128,AES256

5.檢視錶空間是否加密
> select tablespace_name,encrypted from dba_tablespaces;
TABLESPACE_NAME                ENC
------------------------------ ---
SYSTEM                         NO
SYSAUX                         NO
UNDOTBS1                       NO
TEMP                           NO
USERS                          NO
EXAMPLE                        NO
ENCHZH1                        YES

kingsql偶爾筆記（原創）