Re: impdp with encryption on different source/target

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.
-Prasad

On Fri, Feb 1, 2008 at 12:43 PM, J. Dex <cemail_219_at_hotmail.com> 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!<http://club.live.com/star_shuffle.aspx?icid=starshuffle_wlmailtextlink_jan>
>

--
http://www.freelists.org/webpage/oracle-l