******************************************************************************
* 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