Developing Transparent Data Encryption with Oracle 10g XE
731404Nov 4 2009 — edited Nov 9 2009I'm currently developing an application which will require encrypted columns in some tables, I will recommended the client purchase an Oracle database for the application and have installed Oracle 10g XE to begin development, I've found that I cannot create tables with TDE columns tho as I cannot create a wallet. I searched the forums and found that wallet manager is not available with Oracle XE.
My plan was to develop the application then provide the create scripts to the client's DBA so they can create the data tables in their Oracle database... Can I develop the application without TDE and then tell the DBA this needs to be implemented in the release version of the application? Does the application need to know the wallet/TDE password in order to encrypt/decrypt columns!?
Any ideas how I could go about developing the clients database in Oracle XE without having access to TDE?