cross Platforms - Transportable Tablespaces

 Across Platforms Using Transportable Tablespaces :

Step for Cross platform Transportable tablespace

0.1 mkdir /u01/app/oracle/dumpdir
0.2 Create directory dumpdir as '/u01/app/oracle/dumpdir';

1. expdp  TRANSPORT_TABLESPACES=TEST_EXP DUMPFILE=expdp_TEST_EXP.dmp  DIRECTORY=dumpdir TRANSPORT_FULL_CHECK=y

2. RMAN> CONVERT TABLESPACE sales_1,sales_2 

         TO PLATFORM 'Microsoft Windows NT'

         FORMAT '/temp/%U';

3. Copy to Destination Server/Host

4. RMAN> CONVERT DATAFILE 

         '/hq/finance/work/tru/tbs_31.f',

         '/hq/finance/work/tru/tbs_32.f',

         '/hq/finance/work/tru/tbs_41.f'

         TO PLATFORM="Solaris[tm] OE (32-bit)"

         FROM PLATFORM="HP TRu64 UNIX"

         DB_FILE_NAME_CONVERT=

         "/hq/finance/work/tru/", "/hq/finance/dbs/tru"

         PARALLELISM=5;

5. IMPDP system/password DUMPFILE=expdat.dmp DIRECTORY=dpump_dir

   TRANSPORT_DATAFILES=

   /salesdb/sales_101.dbf,

   /salesdb/sales_201.dbf

   REMAP_SCHEMA=(dcranney:smith) REMAP_SCHEMA=(jfee:williams)

6. ALTER TABLESPACE sales_1 READ WRITE;

   ALTER TABLESPACE sales_2 READ WRITE;