RE: sending a copy of database to vendor

From: Tefft, Michael J <Michael.J.Tefft_at_snapon.com>
Date: Mon, 24 Jun 2019 20:07:16 +0000
Message-ID: <48161f3b875240ec85a0ee24b47a4f3f_at_snapon.com>

You should be able to

            DBMS_DATAPUMP.set_parameter (handle   => h1,
                                         name     => 'ENCRYPTION',
                                         VALUE    => 'NONE');

See https://docs.oracle.com/en/database/oracle/oracle-database/12.2/sutil/oracle-data-pump-export-utility.html#GUID-16EEA783-A7E8-4FD3-A7B1-C92428C94C66

Mike Tefft

From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Mark Burgess Sent: Thursday, June 20, 2019 5:07 AM
To: oracle-l_at_freelists.org; Jack van Zanen <jack_at_vanzanen.com> Subject: Re: sending a copy of database to vendor

**CAUTION: This email originated from outside of Snap-on. Use caution when clicking on links or opening attachments. Contact the sender by phone to validate the contents. ** Yes fairly sure that was the case.

There is a note on MOS that describes the problem as well. On 20 Jun 2019, 5:05 PM +1000, Jack van Zanen <jack_at_vanzanen.com<mailto:jack_at_vanzanen.com>>, wrote:

Are you sure about that?

On Thu, 20 Jun. 2019, 16:44 Mark Burgess, <mark_at_burgess-consulting.com.au<mailto:mark_at_burgess-consulting.com.au>> wrote: Jack if the tablespace you have exported from is encrypted you will need the wallet to impdp on the destination.

Clone the db - decrypt the tablespace and then expdp again and you should be ok to imp on the destination without needing the wallet. On 20 Jun 2019, 3:51 PM +1000, Jack van Zanen <jack_at_vanzanen.com<mailto:jack_at_vanzanen.com>>, wrote:

Hi All

Oracle 12C RAC Exadata (Cloud at customer)

We need to send a copy of our database to the vendor so they can troubleshoot issues . I send them a compressed datapump export but they are having issues with loading this.

They want an RMAN backup but our databases are encrypted so if we send them RMAN backup we also need to send them the KEYS which we do not want to do.

Is there a way around this ?

Jack van Zanen

[https://docs.google.com/uc?id=0BwovDucFT1fXaEREVHNWRWZyNjg&export=download]

---

This e-mail and any attachments may contain confidential material for the sole use of the intended recipient. If you are not the intended recipient, please be aware that any disclosure, copying, distribution or use of this e-mail or any attachment is prohibited. If you have received this e-mail in error, please contact the sender and delete all copies. Thank you for your cooperation

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

Received on Mon Jun 24 2019 - 22:07:16 CEST