Re: impdp with encryption on different source/target

From: Stefan Knecht <>
Date: Sat, 2 Feb 2008 11:34:23 +0100
Message-ID: <>

There is no connection between the encryption that takes place in the export dumpfile and the encryption in the database tables.

The master protects the keys used to encrypt column data (one key per table if I recall correctly).

When you're exporting encrypted columns, per default they're written to the dumpfile in plaintext form. To avoid this, you can supply the encryption_password parameter, which will cause the data to be stored encrypted (and protected solely by your password, no connection to the master key there).

When you're importing the datafile, wether it contains encrypted data or not, the data can be imported into encrypted columns or plaintext columns. The encryption inside the new database is controlled by the master key of the new database. Should your dumpfile be encrypted with a password, you'll have to supply that password upon import to be able to decrypt the data. Again, there's no connection to the master key of the new database there.




On Feb 1, 2008 9:43 PM, J. Dex <> wrote:

> I have a expdp file taken from Database A on Server A where the data was
> encrypted and then stored in an encrypted file with encryption_password. I
> want to import the data into Database B on Server B. My understanding is
> that I need to use the encryption_password to use that file, however, since
> the master key (wallet) on the two servers is different, how can I import
> the data into Database B on Server B without running into issues? What is
> the impdp command that should be used? Do you have to regenerate something
> after importing the data into Database B on Server B since the master key
> will not be in sync with the imported data?
> ------------------------------
> Climb to the top of the charts! Play the word scramble challenge with star
> power. Play now!<>


Stefan P Knecht
Senior Consultant
Infrastructure Managed Services

Trivadis AG
Europa-Strasse 5
CH-8152 Glattbrugg

Phone +41-44-808 70 20
Fax +41-808 70 12
Mobile +41-79-571 36 27


Received on Sat Feb 02 2008 - 04:34:23 CST

Original text of this message