Database Utilities (MOSC)

MOSC Banner

Export dump of data stored TDE tablespace

edited Oct 28, 2021 6:51PM in Database Utilities (MOSC) 2 commentsAnswered

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?

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center