Database Administration (MOSC)

MOSC Banner

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

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center