How do we migrate data between DBs with different encryption keys?
We have 2 databases that are encrypted using TDE - Database A is encrypted with one key, and Database B is encrypted with another key. We have been researching, but have yet to determine, other than decrypting the tablespaces in both databases A and B, using data pump to export the data from database A and into database B, then re-encrypting the tablespaces. As we are sure that we are not the only ones who have encountered this issue, any assistance would be appreciated. We have yet to find another solution.
DB: 19c patched
OS: OL8