impdp fails
Hi,
On 11.2.0.4 on AIX
I ran:
impdp SYSTEM REMAP_TABLE=system.TAB1:system.TAB2 directory=DATA_PUMP_DIR dumpfile=exp_TAB1.dmp logfile=imp_TAB1.log
ORA-31604: invalid transform NAME parameter "MODIFY" for object type PRE_TABLE_ACTION in function ADD_TRANSFORM
Then I followed note 1596495.1
impdp SYSTEM REMAP_TABLE=system.TAB1:system.TAB2 directory=DATA_PUMP_DIR dumpfile=exp_TAB1.dmp logfile=imp_TAB1.log exclude=PRE_TABLE_ACTION
But I had:
ORA-31604: invalid transform NAME parameter "MODIFY" for object type PROCACT_INSTANCE in function ADD_TRANSFORM
then:
impdp SYSTEM REMAP_TABLE=system.TAB1:system.TAB2 directory=DATA_PUMP_DIR dumpfile=exp_TAB1.dmp logfile=imp_TAB1.log exclude=PRE_TABLE_ACTION,PROCACT_INSTANCE