Transportable tablespaces and TDE
I have a client who wants to migrate an 11.2.0.4 database from Solaris to Oracle 12.1.0.2 on OL Linux 7.2. Normally, there would be nothing problematic in that task, the tablespaces containing the user data would be migrated to 12c using transportable tablespaces and problem would be solved. However, there is a twist: the customer is a bank and is using TDE (transparent data encryption). All of the tablespaces that need to be moved from Solaris to Linux are encrypted. I have two questions:
- Is the transportable tablespace method that I know and love supported with TDE?
- Do you have any documentation about this? I would be very grateful for some documentation.