Export dump of data stored TDE tablespace
I need to create an export dump of a schema in the 12.1.0.2 database. Some of the data in the schema reside on a TDE tablespace. I am sure you need to create a TDE tablespace and have an encryption key password before you can import data successfully. How can I import without sharing/knowing the encryption key password?
Can I update the TDE encryption to a temporary password on the source, export dump, import dump using the temporary key, and reset to a new password on the source? Is this the only option or can you think of any other ways to deal with expdp/impdp of TDE tablespace data?