So, it sounds like I don't need a certificate to do this, but I do need
to back out and start over. To do that, it seems that I should
- decrypt the columns I have currently encrypted with my current key
- get rid of the current wallet, located at
ORACL_HOME\admin\<sid>\wallet (is this as simple as deleting the
current wallet file? I don't find any sql syntax that looks like it
would reverse the 'ALTER SYSTEM SET ENCRYPTION KEY....')
- use Wallet Manager to create a new key and wallet
- encrypt the designated columns.
sanity check?
Received on Wed May 03 2006 - 08:27:17 CDT
