Re: impdp with encryption on different source/target

From: Prasad <>
Date: Fri, 1 Feb 2008 14:08:35 -0800
Message-ID: <>

it has been a while I did something like this . and the syntax were as below expdp system/manager dumpfile=test.dmp directory=tmp_dir tables=scott.empencryption_password=welcome123 impdp system/manager tables=emp dumpfile=test.dmp directory=tmp_dir encryption_password=welcome123 REMAP_SCHEMA=scott:system remap_tablespace=users:system

after reboot of database

SQL> alter system set encryption wallet open identified by "welcome123";

hope this helps.

On Fri, Feb 1, 2008 at 12: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!<>

Received on Fri Feb 01 2008 - 16:08:35 CST

Original text of this message