-- IMPDP_TRANS_TBSP_SOL.par --
DIRECTORY=DATA_PUMP_DIR
DUMPFILE=impdp_site_trans_tbsp_sol.dmp

LOGFILE=site_imp-dump_tdb-solaris.log

TRANSPORT_DATAFILES=

/dtaarea2/oracle/data/site/users01.dbf,

/dtaarea2/oracle/datafiles/site/site_data_01.dbf,

/dtaarea2/oracle/datafiles/site/site_data_02.dbf,

/dtaarea2/oracle/datafiles/site/site_data_03.dbf,

/dtaarea2/oracle/datafiles/site/site_data_04.dbf,

/dtaarea2/oracle/datafiles/site/site_data_05.dbf,

/dtaarea2/oracle/datafiles/site/site_data_06.dbf,

/dtaarea2/oracle/datafiles/site/sqlt_data_01.dbf,

/dtaarea3/oracle/datafiles/site/audit_mv_data_01.dbf,

/dtaarea3/oracle/datafiles/site/audit_mv_data_02.dbf,

/dtaarea3/oracle/datafiles/site/audit_mv_data_03.dbf,

/dtaarea3/oracle/datafiles/site/audit_mv_data_04.dbf,

/dtaarea3/oracle/datafiles/site/audit_mv_data_05.dbf,

/dtaarea3/oracle/datafiles/site/audit_mv_data_06.dbf,

/dtaarea3/oracle/datafiles/site/audit_mv_index_01.dbf,

/dtaarea3/oracle/datafiles/site/audit_mv_index_02.dbf,

/dtaarea3/oracle/datafiles/site/ent_entity_data_01.dbf,

/dtaarea3/oracle/datafiles/site/ent_entity_data_02.dbf,

/dtaarea3/oracle/datafiles/site/ent_entity_data_03.dbf,

/dtaarea3/oracle/datafiles/site/ent_entity_data_04.dbf,

/dtaarea3/oracle/datafiles/site/ent_entity_index_01.dbf,

/dtaarea3/oracle/datafiles/site/ent_entity_index_02.dbf,

/dtaarea3/oracle/datafiles/site/ent_individual_data_01.dbf,

/dtaarea3/oracle/datafiles/site/ent_individual_data_02.dbf,

/dtaarea3/oracle/datafiles/site/ent_individual_data_03.dbf,

/dtaarea3/oracle/datafiles/site/ent_individual_data_04.dbf,

/dtaarea3/oracle/datafiles/site/ent_individual_index_01.dbf,

/dtaarea3/oracle/datafiles/site/ent_individual_index_02.dbf,

/dtaarea3/oracle/datafiles/site/ent_industry_occupation_data_01.dbf,

/dtaarea3/oracle/datafiles/site/ent_industry_occupation_data_02.dbf,

/dtaarea3/oracle/datafiles/site/ent_industry_occupation_data_03.dbf,

/dtaarea3/oracle/datafiles/site/ent_industry_occupation_data_04.dbf,

/dtaarea3/oracle/datafiles/site/ent_industry_occupation_index_01.dbf,

/dtaarea3/oracle/datafiles/site/ent_industry_occupation_index_02.dbf,

/dtaarea3/oracle/datafiles/site/ent_location_data_01.dbf,

/dtaarea3/oracle/datafiles/site/ent_location_data_02.dbf,

/dtaarea3/oracle/datafiles/site/ent_location_data_03.dbf,

/dtaarea3/oracle/datafiles/site/ent_location_data_04.dbf,

/dtaarea3/oracle/datafiles/site/ent_location_data_05.dbf,

/dtaarea3/oracle/datafiles/site/ent_location_index_01.dbf,

/dtaarea3/oracle/datafiles/site/ent_location_index_02.dbf,

/dtaarea3/oracle/datafiles/site/ent_location_index_03.dbf,

/dtaarea3/oracle/datafiles/site/ent_organization_data_01.dbf,

/dtaarea3/oracle/datafiles/site/ent_organization_data_02.dbf,

/dtaarea3/oracle/datafiles/site/ent_organization_data_03.dbf,

/dtaarea3/oracle/datafiles/site/ent_organization_data_04.dbf,

/dtaarea3/oracle/datafiles/site/ent_organization_index_01.dbf,

/dtaarea3/oracle/datafiles/site/ent_organization_index_02.dbf,

/dtaarea3/oracle/datafiles/site/ent_trade_name_data_01.dbf,

/dtaarea3/oracle/datafiles/site/ent_trade_name_data_02.dbf,

/dtaarea3/oracle/datafiles/site/ent_trade_name_data_03.dbf,

/dtaarea3/oracle/datafiles/site/ent_trade_name_data_04.dbf,

/dtaarea3/oracle/datafiles/site/ent_trade_name_index_01.dbf,

/dtaarea3/oracle/datafiles/site/ent_trade_name_index_02.dbf,

/dtaarea3/oracle/datafiles/site/site_data_07.dbf,

/dtaarea3/oracle/datafiles/site/site_data_08.dbf,

/dtaarea3/oracle/datafiles/site/site_data_09.dbf,

/dtaarea3/oracle/datafiles/site/site_data_10.dbf,

/dtaarea3/oracle/datafiles/site/site_data_11.dbf,

/dtaarea3/oracle/datafiles/site/site_data_12.dbf,

/dtaarea3/oracle/datafiles/site/site_data_13.dbf,

/dtaarea3/oracle/datafiles/site/site_data_14.dbf,

/dtaarea3/oracle/datafiles/site/site_data_16.dbf,

/dtaarea3/oracle/datafiles/site/site_master_data_01.dbf,

/dtaarea3/oracle/datafiles/site/site_work_data_01.dbf,

/dtaarea3/oracle/datafiles/site/sitemaster1_work1_data_01.dbf,

/dtaarea3/oracle/datafiles/site/sitemaster1_work1_data_02.dbf,

/dtaarea3/oracle/datafiles/site/sitemaster1_work1_data_03.dbf,

/dtaarea3/oracle/datafiles/site/sitemaster1_work1_data_04.dbf,

/dtaarea3/oracle/datafiles/site/odi_user_data_01.dbf,

/dtaarea3/oracle/datafiles/site/odi_user_data_02.dbf,

/dtaarea3/oracle/datafiles/site/rev_acc_data_01.dbf,

/dtaarea3/oracle/datafiles/site/rev_acc_data_02.dbf,

/dtaarea3/oracle/datafiles/site/rev_acc_data_03.dbf,

/dtaarea3/oracle/datafiles/site/rev_acc_data_04.dbf,

/dtaarea3/oracle/datafiles/site/rev_acc_form_type_data_01.dbf,

/dtaarea3/oracle/datafiles/site/rev_acc_form_type_data_02.dbf,

/dtaarea3/oracle/datafiles/site/rev_acc_form_type_data_03.dbf,

/dtaarea3/oracle/datafiles/site/rev_acc_form_type_data_04.dbf,

/dtaarea3/oracle/datafiles/site/rev_acc_form_type_hist_index_01.dbf,

/dtaarea3/oracle/datafiles/site/rev_acc_form_type_hist_index_02.dbf,

/dtaarea3/oracle/datafiles/site/rev_acc_form_type_history_data_01.dbf,

/dtaarea3/oracle/datafiles/site/rev_acc_form_type_history_data_02.dbf,

/dtaarea3/oracle/datafiles/site/rev_acc_form_type_history_data_03.dbf,

/dtaarea3/oracle/datafiles/site/rev_acc_form_type_history_data_04.dbf,

/dtaarea3/oracle/datafiles/site/rev_acc_form_type_index_01.dbf,

/dtaarea3/oracle/datafiles/site/rev_acc_form_type_index_02.dbf,

/dtaarea3/oracle/datafiles/site/rev_acc_index_01.dbf,

/dtaarea3/oracle/datafiles/site/rev_acc_index_02.dbf,

/dtaarea3/oracle/datafiles/site/rev_entity_acc_data_01.dbf,

/dtaarea3/oracle/datafiles/site/rev_entity_acc_data_02.dbf,

/dtaarea3/oracle/datafiles/site/rev_entity_acc_data_03.dbf,

/dtaarea3/oracle/datafiles/site/rev_entity_acc_data_04.dbf,

/dtaarea3/oracle/datafiles/site/rev_entity_acc_index_01.dbf,

/dtaarea3/oracle/datafiles/site/rev_entity_acc_index_02.dbf,

/dtaarea3/oracle/datafiles/site/revled_rev_period_data_01.dbf,

/dtaarea3/oracle/datafiles/site/revled_rev_period_data_02.dbf,
/dtaarea3/oracle/datafiles/site/revled_rev_period_data_03.dbf,

/dtaarea3/oracle/datafiles/site/revled_rev_period_data_04.dbf,

/dtaarea3/oracle/datafiles/site/revled_rev_period_data_05.dbf,

/dtaarea3/oracle/datafiles/site/revled_rev_period_index_01.dbf,

/dtaarea3/oracle/datafiles/site/revled_rev_period_index_02.dbf,

/dtaarea3/oracle/datafiles/site/revled_rev_period_index_03.dbf,

/dtaarea3/oracle/datafiles/site/revled_rev_period_index_04.dbf,

/dtaarea4/oracle/datafiles/site/ent_entity_data_05.dbf,

/dtaarea4/oracle/datafiles/site/ent_individual_data_05.dbf,

/dtaarea4/oracle/datafiles/site/ent_individual_index_03.dbf,

/dtaarea4/oracle/datafiles/site/ent_industry_occupation_index_03.dbf,

/dtaarea4/oracle/datafiles/site/site_data_15.dbf,

/dtaarea4/oracle/datafiles/site/site_data_16.dbf,

/dtaarea4/oracle/datafiles/site/site_data_17.dbf,

/dtaarea4/oracle/datafiles/site/site_data_18.dbf,

/dtaarea4/oracle/datafiles/site/sitestg_data_01.dbf,

/dtaarea4/oracle/datafiles/site/sitestg_data_02.dbf,

/dtaarea4/oracle/datafiles/site/sitestg_index_01.dbf,

/dtaarea4/oracle/datafiles/site/sitestg_index_02.dbf,

/dtaarea4/oracle/datafiles/site/odi_user_data_03.dbf

-- Data Pumps execution --
=========================================================================================
 ** AFFECTED DATAFILE RECREATED BEFORE DATA PUMP EXECUTION **
=========================================================================================
$ impdp system/password parfile=IMPDP_TRANS_TBSP_SOL.par


Import: Release 10.2.0.5.0 - 64bit Production on Thursday, 14 June, 2017 
Copyright (c) 2003, 2007, Oracle.  All rights reserved.


Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 - 64bit Production

Master table "SYSTEM"."SYS_IMPORT_TRANSPORTABLE_01" successfully loaded/unloaded

Starting "SYSTEM"."SYS_IMPORT_TRANSPORTABLE_01":  system/******** parfile=IMPDP_TRANS_TBSP_SOL.par
Processing object type TRANSPORTABLE_EXPORT/PLUGTS_BLK

ORA-39123: Data Pump transportable tablespace job aborted

ORA-29349: tablespace 'AUDIT_MV_INDEX' already exist


Job "SYSTEM"."SYS_IMPORT_TRANSPORTABLE_01" stopped due to fatal error 

=========================================================================================
 ** AFFECTED INDEX DATAFILE DROPPED PRIOR TO DATA PUMP EXECUTION **
=========================================================================================
$ impdp system/password parfile=IMPDP_TRANS_TBSP_SOL.par


Import: Release 10.2.0.5.0 - 64bit Production on Thursday, 15 June, 2017 
Copyright (c) 2003, 2007, Oracle.  All rights reserved.


Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 - 64bit Production

Master table "SYSTEM"."SYS_IMPORT_TRANSPORTABLE_01" successfully loaded/unloaded

Starting "SYSTEM"."SYS_IMPORT_TRANSPORTABLE_01":  system/******** parfile=IMPDP_TRANS_TBSP_SOL.par
Processing object type TRANSPORTABLE_EXPORT/PLUGTS_BLK

ORA-39123: Data Pump transportable tablespace job aborted

ORA-01565: error in identifying file '/dtaarea3/oracle/datafiles/site/audit_mv_index_01.dbf'

ORA-27037: unable to obtain file status

SVR4 Error: 2: No such file or directory

Additional information: 3


Job "SYSTEM"."SYS_IMPORT_TRANSPORTABLE_01" stopped due to fatal error