Re: sending a copy of database to vendor

Yes, either specify encryption none or don't add any encryption parameter, which also means none...

Thank you

On Tue, 25 Jun. 2019, 06:07 Tefft, Michael J, <Michael.J.Tefft_at_snapon.com> wrote:

> 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>, wrote:
>
> Are you sure about that?
>
>
>
>
>
>
>
> On Thu, 20 Jun. 2019, 16:44 Mark Burgess, <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>, 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
>
>
>
>
> -------------------------
> 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