Oracle Database Appliance (ODA) (MOSC)

MOSC Banner

How do I import an encrypted datapump file into a remote TDE-enabled database?

in Oracle Database Appliance (ODA) (MOSC) 10 commentsAnswered ✓

I am using an x8-2s single node ODA on version 19.13 and I am trying to test my encrypted datapump exports by importing them into a different pluggable database on a remote ODA with only the original key (not a password).

Scenario: I have two ODAs.

ODA1 hosts our production TDE-enabled pluggable database.

ODA2 is at a remote site that hosts a test pluggable database that is TDE-enabled.

We would like to restore the datapump export from ODA1 to the test database on ODA2 without affecting out ODA2's keys.

Datapump exports on TDE-enabled databases use a wallet in ASM for encryption.

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

Instructions for posting

×

1. Select a discussion category from the picklist.


2. Enter a title that clearly identifies the subject of your question.


3. In the body, insert detailed information, including Oracle product and version.


Please abide by the Oracle Community guidelines and refrain from posting any customer or personally identifiable information (PI/CI).


Cloud / Fusion customers - Our Cloud community has moved! Please go to Cloud Customer Connect .


New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center