I spent yesterday looking at the Tablespace Encryption feature in Oracle 11g. If you’ve used the Transparent Data Encryption (TDE) feature in 10g release 2, you’ll see this is more of the same. The difference here is eveything in the tablespace is encrypted, rather than having to decide on a column-by-column basis. Just create the appropriate tablespace and Bob’s your uncle!
You may notice the article conveniently side-steps the Hardware Security Modules related functionality. I don’t have one so I can’t test it out. š
For most of the stuff I work on, encrypting all the columns in a table is overkill, but I guess there are some areas where this is a big priority. It’s good to know it’s there in case you ever need it. š
Cheers
Tim…
That’s going to be big fun when you’ve lost the wallet and need to restore/recover š
You need a backup of your wallet, and a backup of your backup wallet , and a backup of your backup of your backup wallet. š
Tim
The link to the 10gR2 article on TDE is broken. It should be: https://oracle-base.com/articles/10g/TransparentDataEncryption_10gR2.php
Cheers, APC
Hi.
I really don’t know what is going on with my blog. Since I moved to WordPress 2.5 this sort of thing is happening all the time. I think maybe my theme doesn’t work well with 2.5???
I tried the link and as you pointed out, it was wrong. I went into the admin screen and checked it and the text was correct. I saved the page, without modification, and now the link works fine. I don’t understand. š
Cheers
Tim…
PS. Cheers for the heads-up Andrew. š