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

From: Powell, Mark <>
Date: Fri, 24 Feb 2017 20:35:26 +0000
Message-ID: <DF4PR84MB0204244072AC1FABA5B38C09CC520_at_DF4PR84MB0204.NAMPRD84.PROD.OUTLOOK.COM>

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: <> on behalf of Janardhana Babu Donga <> Sent: Friday, February 24, 2017 3:08:22 PM To: ''
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, ASM New Server: Linux 6, Oracle, ACFS

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

Received on Fri Feb 24 2017 - 21:35:26 CET

Original text of this message