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
Oracle 12c – Export TDE Encrypted Table Using expdp/impdp
impdporacleoracle-12ctransparent-data-encryption
Related Question
- Oracle 12c – Installing expdp and impdp on Linux
- Oracle – Error ORA-00918 Not Raised with FETCH Command
- Oracle – How to Encrypt DBLink
- Measuring Character Set Conversion
- Sql-server – Turn TDE off when restoring SQL databases
- Oracle 12c – How to Create a DB Link to a Database with Failover in TNS
- Does the target database need to have the same structure of the source database before to use IMPDP
Best Answer
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.