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@xxxxxxxxxx>
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@xxxxxxxxxxxxx [mailto:
oracle-l-bounce@xxxxxxxxxxxxx] *On Behalf Of *Mark Burgess
*Sent:* Thursday, June 20, 2019 5:07 AM
*To:* oracle-l@xxxxxxxxxxxxx; Jack van Zanen <jack@xxxxxxxxxxxx>
*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@xxxxxxxxxxxx>, wrote:
Are you sure about that?
On Thu, 20 Jun. 2019, 16:44 Mark Burgess, <mark@xxxxxxxxxxxxxxxxxxxxxxxxx>
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@xxxxxxxxxxxx>, 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
