透明加密(TDE,Transparent Data Encryption)的作用：防止丢失介质后会被别人读取到数据。在wallet打开的情况下，使用sql语句查询实际上是没有限制的。
1.设定wallet的位置F:\app\Administrator\product\11.2.0\dbhome_1\NETWORK\ADMIN\sqlnet.ora,数据库需要重启
ENCRYPTION_WALLET_LOCATION = (SOURCE= (METHOD=file) (METHOD_DATA= (DIRECTORY=F:\app\Administrator\product\11.2.0\wallet))) 2.在wallet里面创建key sql> alter system set encryption key authenticated by "gg"; alter system set encryption key authenticated by "gg" * 第 1 行出现错误: ORA-28368: 无法自动创建 wallet 解决方法，需要在F:\app\Administrator\product\11.2.0下创建一个wallet目录。 3.创建表 drop table test purge; drop table test1 purge; create table test ( id number,name varchar2(50) encrypt using 'AES192' ); insert into test values(1,'gg1'); commit; create table test1 ( id number,name varchar2(50) encrypt ); insert into test1 values(1,'gg1'); commit; sql> select * from test; ID NAME ---------- ---------------- 1 gg1 已用时间: 00: 00: 00.01 sql> select * from test1; ID NAME ---------- ---------------- 1 gg1 alter system set wallet close identified by "gg"; sql> select * from test; select * from test * 第 1 行出现错误: ORA-28365: Wallet 未打开 ALTER SYSTEM SET WALLET open IDENTIFIED BY "gg"; sql> select * from test; ID NAME ---------- ---------------- 1 gg1 相关的几个视图是： V$ENCRYPTION_WALLET V$ENCRYPTION_WALLET dba_encrypted_columns 原文链接：https://www.f2er.com/oracle/209676.html