If this is your first visit, be sure to
check out the FAQ by clicking the
link above. You may have to register
before you can post: click the register link above to proceed. To start viewing messages,
select the forum that you want to visit from the selection below.

I moved this to the Administration Forum where you might get an answer. Transparent Data Encryption is meant for data that resides directly in the database, not as a external table. You can use the DBMS_OBSFUSCATION toolkit to encrypt or decrypt data from external tables. But you need to write your own wrapper code to make it work and you need to store the encryption key somewhere, so that it can be accessed when needed.