Posts

Showing posts with the label tde_wallet_full_path

TransparentDataEncryption (TDE) column implementation

Here are the TDE column implementation steps: ð  Run below statements sequentially: One sqlplus session is enough for entire action plan. Database : orcl Server : xxxxxxxxx OS User : tdeuser conn / as syskm define tde_wallet_full_path=&tde_wallet_full_path define password=&password col WRL_PARAMETER for a60 col WRL_TYPE for a8 col STATUS for a20 col WALLET_TYPE for a10 set lines 200 select * from gv$encryption_wallet; administer key management create keystore '&&tde_wallet_full_path' identified by "&&password"; select * from v$encryption_wallet; administer key management set keystore open identified by "&&password"; select * from v$encryption_wallet; administer key management create key identified by "&&password" with backup; select * from v$encryption_wallet; select key_id,activation_time from v$encryption_keys; administer key management use key ...