1) 采用下面方式收集跟踪日志:
impdp system/********directory=DATADUMP dumpfile=t_product_%U.dmptables=t_product table_exists_action=appendlogfile=expdp_iden_product.log trace=4C0300;
2) 生成的日志在/opt/oracle/diag/rdbms/stdbora/stdbora/trace命名为:
<SID>_dm<number>_<process_id>.trc
<SID>_dw<number>_<process_id>.trc
<SID>_ora_<process_id>.trc
3) 如果执行impdp出现权限不足报错,需要执行下面SQL授权:
su - oracle
sqlplus / as sysdba
GRANTimp_full_database TO system;