11gR2 TSPIT with User defined datatypes.
Do let us know if there are any restrictions on TSPITR when Users defined datatypes is used.
TSPIT recovery Impdp failed with error ORA-31684:
EXPDP> ******************************************************************************
EXPDP> Dump file set for SYS.TSPITR_EXP_pbds is:
EXPDP> /oradata/app/oracle/product/11.2.0.1/orasw/aux_dest/tspitr_pbds_73812.dmp
EXPDP> ******************************************************************************
EXPDP> Datafiles required for transportable tablespace SYN:
EXPDP> /oradata/app/oracle/product/11.2.0.1/orasw/database/orasw/datafile/o1_mf_syn_6b0xc
k65_.dbf
EXPDP> Job "SYS"."TSPITR_EXP_pbds" successfully completed at 10:56:58
Export completed
contents of Memory Script:
{
# shutdown clone before import
shutdown clone immediate
# drop target tablespaces before importing them back
sql 'drop tablespace SYN including contents keep datafiles';
EXPDP> ******************************************************************************
EXPDP> Dump file set for SYS.TSPITR_EXP_pbds is:
EXPDP> /oradata/app/oracle/product/11.2.0.1/orasw/aux_dest/tspitr_pbds_73812.dmp
EXPDP> ******************************************************************************
EXPDP> Datafiles required for transportable tablespace SYN:
EXPDP> /oradata/app/oracle/product/11.2.0.1/orasw/database/orasw/datafile/o1_mf_syn_6b0xc
k65_.dbf
EXPDP> Job "SYS"."TSPITR_EXP_pbds" successfully completed at 10:56:58
Export completed
contents of Memory Script:
{
# shutdown clone before import
shutdown clone immediate
# drop target tablespaces before importing them back
sql 'drop tablespace SYN including contents keep datafiles';
0