Make sure character set are same on source and target
1- To check endianness of both platforms
SELECT d.PLATFORM_NAME, ENDIAN_FORMAT FROM V$TRANSPORTABLE_PLATFORM tp,
V$DATABASE d WHERE tp.PLATFORM_ID = d.PLATFORM_ID;
In this case, both Oracle Solaris x86 and Oracle Enterprise Linux have little
endian format, so no endian conversion is necessary.
2- To check if tablespaces are self contained
EXECUTE DBMS_TTS.TRANSPORT_SET_CHECK('hr_1,hr_2', TRUE);
3- To check any violations
SELECT * FROM TRANSPORT_SET_VIOLATIONS
4- Create directory object on source database.
Create Directory dp_dir as '/u01/app/datafiles';
5- Place user tablespaces in read only mode.
6- expdp system/sys2db1 full=y transportable=always version=12 directory=dp_dir
dumpfile=db1_full_tts.dmp logfile=db1_full_tts_exp.log
exclude=TABLESPACE:"IN\('USERS'\,'EXAMPLE'\,'SYSAUX'\)" exclude=SCHEMA:"IN\
('HR'\,'SH'\,'PM'\,'IX'\,'OE'\,'SYSMAN'\,'APEX_030200'\,'APEX_PUBLIC_USER'\,'WMSYS'
\,'ORDDATA'\,'FLOWS_FILES',\'OUTLN'\,'OWBSYS',\'SYSTEM')"
7- Move datafiles and export dump file from source to target
8- Create directory object on the destination database
create directory dp_dir as '/u01/app/datafiles';
9- grant read, write on directory to system;
10- Invoke full transportable import on destination database.
impdp system/sys2db2 directory=dp_dir dumpfile=db1_full_tts.dmp
logfile=db2_full_tts_imp.log transport_datafiles='','',''