ITPub博客

------------scenario 1SQL> alter table emp2 modify (sal encrypt no salt) ;alter table emp2 modify (sal encrypt no salt)ORA-28348: index defined on the specified column cannot be encrypted---- solution :1,check function-based index on the encrypted column , if needed , drop the function index.------------scenario 2SQL> create index idx_emp2_sal2 on emp2(sal desc) ;create index idx_emp2_sal2 on emp2(sal desc)ORA-28337: the specified index may not be defined on an encrypted column--- explanat

Oracle10gR2 中 Oracle Wallet 的初步使用和维护http://blog.sina.com.cn/s/blog_4d8a2c970100fjks.htmlwallet useful in : 1, client auto login databae. 2, database data encryption.-- detail settings1, in client side , set following parameters in sqlnet.ora file .WALLET_LOCATION =(SOURCE =(METHOD = FILE)(METHOD_DATA =(DIRECTORY = C:temp)))# THE FOLLOWING PARAMETER IS NEEDED FOR AUTO LOGIN. IF SET TO FALSE, THEN DO NOT ALLOW AUTO LOGIN FEATURE.SQLNET.WALLET_OVERRIDE = TRUE -- command to create credentia

第一种错误：不能建立WALLET现象：15:11:53 SYS> alter system set encryption key authenticated by "topsecrect" ;alter system set encryption key authenticated by "topsecrect"*ERROR at line 1:ORA-28368: cannot auto-create wallet原因：缺少相关路径，默认位置是 $oracle_baseadmin$ora_SIDwallet,可能通过SQLNET.ORA 加入相关参数修改。ENCRYPTION_WALLET_LOCATION=(SOURCE=(METHOD=FILE)(METHOD_DATA=(DIRECTORY=D:oradatawallet))) 第一种错误：不能打开WALLET现象：15:36:33 SYS> alter system s