******************************************************************************
* Description: TDE tablespace with table cotains LONG data type via data pump
* Date: 01:48 PM EST, 08/27/2017
******************************************************************************
<1> Step 1 - Create TDE secured tablespace:
|
|__ SQL> CREATE TABLESPACE AMEX_DATA_SEC DATAFILE '+DATA' SIZE 2G AUTOEXTEND ON NEXT 1056M ENCRYPTION USING 'AES256' DEFAULT STORAGE(ENCRYPT);
<2> Step 2 - Expdp/Impdp the tables with LONG data type to TDE tablespace:
|
|__ SQL> create directory DP_AMEX as '/home/oracle/micore/tde/AMEX_DATA';
|
|
|__ CMD> /u01/app/oracle/product/11.2.0.4/dbhome_1/bin/expdp \'/ as sysdba\' parfile=AMEX_DATA_expdp.par
|
|
| DIRECTORY=DP_AMEX
| parallel=4
| METRICS=Y
| dumpfile=AMEX_DATA_expdp.dmp
| logfile=AMEX_DATA_expdp.log
| tables=AMEXJPORTAL.JBP_CMS_WSP_PROP,
| AMEXJPORTAL.JBP_CMS_WSP_REFS,
| AMEXJPORTAL.JBP_CMS_VERSION_NODE,
| AMEXJPORTAL.JBP_INSTANCE,
| AMEXJPORTAL.JBP_CMS_VERSION_PROP,
| AMEXJPORTAL.JBP_CMS_VERSION_REFS,
| AMEXJPORTAL.JBP_CMS_WSP_NODE,
| AMEXJPORTAL.JBP_REGISTRATION_INFO,
| AMEXJPORTAL.JBP_INSTANCE_PER_USER
|
|
|__ CMD> /u01/app/oracle/product/11.2.0.4/dbhome_1/bin/impdp \'/ as sysdba\' parfile=AMEX_DATA_impdp.par
DIRECTORY=DP_AMEX
parallel=4
METRICS=Y
dumpfile=AMEX_DATA_expdp.dmp
logfile=AMEX_DATA_impdp.log
TABLE_EXISTS_ACTION=REPLACE
REMAP_TABLESPACE=AMEX_DATA:AMEX_DATA_SEC
tables=AMEXJPORTAL.JBP_CMS_WSP_PROP,
AMEXJPORTAL.JBP_CMS_WSP_REFS,
AMEXJPORTAL.JBP_CMS_VERSION_NODE,
AMEXJPORTAL.JBP_INSTANCE,
AMEXJPORTAL.JBP_CMS_VERSION_PROP,
AMEXJPORTAL.JBP_CMS_VERSION_REFS,
AMEXJPORTAL.JBP_CMS_WSP_NODE,
AMEXJPORTAL.JBP_REGISTRATION_INFO,
AMEXJPORTAL.JBP_INSTANCE_PER_USER
Your Comments