I have an Oracle 12c database where I have encrypted certain columns of several tables, I want to import or load these tables into another database which does not have TDE enabled, as would be recommended with datapump? or dblink? And if it were the last one, could it be done without having TDE in the destination? thanks


TDE encrypts the data at rest only. As soon as the data is read off the disk, it is decrypted. So if you need to copy the data to a new database instance you can just do a CTAS or IAS over the db link. You should be able to use datapump also, but you have db link between the two database it is the easiest solution.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.