TTS data migration approach
Hello,
Trying to migrate a schema as below:
1) ### Source System ###
Oracle EE (11.2.0.2)
AL32UTF8 and AL16UTF16
HP-UX B.11.31 U ia64
Standard OS file system
2) ### Target System ###
Database Appliance 2.7
Oracle EE (11.2.0.3.7)
AL32UTF8 and AL16UTF16
Linux 2.6.39-400.111.1.el5uek
ASM file system
1) ### Source System ###
Oracle EE (11.2.0.2)
AL32UTF8 and AL16UTF16
HP-UX B.11.31 U ia64
Standard OS file system
2) ### Target System ###
Database Appliance 2.7
Oracle EE (11.2.0.3.7)
AL32UTF8 and AL16UTF16
Linux 2.6.39-400.111.1.el5uek
ASM file system
Single schema to migrate with many tablespaces. Impdp over dblink which completes data import within 2 hours except for 2 tables with large CLOB data that take over 24 hours.These tables with CLOB are in the same tablespace as well as their indexes . FK constraints are referenced outside the tablespace.
Question: Can the tablespace with CLOB data be transferred using TTS? Objective is to use a combination of impdp of tablespaces without CLOB and TTS of tablespace with CLOB to reduce time.
0