DB move (with encrypted Data) to new Server ......
From: Janardhana Babu Donga <jbdonga_at_ucdavis.edu>
Date: Fri, 24 Feb 2017 20:08:22 +0000
Message-ID: <DM3PR08MB1929B3AE66654F7B6EB42E0CB4520_at_DM3PR08MB1929.namprd08.prod.outlook.com>
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).
Date: Fri, 24 Feb 2017 20:08:22 +0000
Message-ID: <DM3PR08MB1929B3AE66654F7B6EB42E0CB4520_at_DM3PR08MB1929.namprd08.prod.outlook.com>
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-lReceived on Fri Feb 24 2017 - 21:08:22 CET