Although I can use the encryption in Oracle databases as shown in 11G OCM Create and Manage encrypted tablespaces, there is a question about the practical uses of encryption.
The main problem with encryption is the management of keys.
My main problem with encryption is that the loss of the encryption key means the total and irretrievable LOSS of DATA.
This I cannot stress enough. Yet I have arguments with other people that they do not fully understand this. They nod their heads sagely. They think that procedures can be set up to prevent this.
They have no operational experience. Things go wrong. Mistakes are made. People misunderstand procedures and concepts. You must be able to recover from mistakes.
So where does this leave encryption? It is a risk versus benefit argument. The benefit of preventing exposure of data must outweigh its potential loss.