RE: DB move (with encrypted Data) to new Server ......

From: Janardhana Babu Donga <jbdonga_at_ucdavis.edu>
Date: Fri, 24 Feb 2017 21:54:35 +0000
Message-ID: <DM3PR08MB1929DE5356193325692C8B52B4520_at_DM3PR08MB1929.namprd08.prod.outlook.com>

Thanks much. I will try.

From: Powell, Mark [mailto:mark.powell2_at_hpe.com] Sent: Friday, February 24, 2017 12:35 PM To: 'oracle-l_at_freelists.org'; Janardhana Babu Donga Subject: Re: DB move (with encrypted Data) to new Server ......

I believe the data will be readable. It should be easy enough to test by exporting one table which uses encryption, importing it, then querying it via a code path that works on the existing system (any query that provides the encryption key).

---

From: oracle-l-bounce_at_freelists.org<mailto:oracle-l-bounce_at_freelists.org> <oracle-l-bounce_at_freelists.org<mailto:oracle-l-bounce_at_freelists.org>> on behalf of Janardhana Babu Donga <jbdonga_at_ucdavis.edu<mailto:jbdonga_at_ucdavis.edu>> Sent: Friday, February 24, 2017 3:08:22 PM To: 'oracle-l_at_freelists.org'
Subject: DB move (with encrypted Data) to new Server ......

I need to move a database from one server to another server (different platform). So, I am using expdp/impdp instead of RMAN. The existing database has lots of encrypted columns (created using DBMS_CRYPTO package).

OLD Server: Linux 5, Oracle 11.2.0.3, ASM New Server: Linux 6, Oracle 11.2.0.4, ACFS

Will they be readable on the new platform after the move? Do I compulsorily need to decrypt before expdp/impdp? Appreciate any help.

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

Received on Fri Feb 24 2017 - 22:54:35 CET