I have started working with Oracle and I was recently tasked with importing a data pump export to a different schema. Once all the required roles were created and the correct REMAP_SCHEMA option was sorted out* I was left with one interesting problem. Everything remapped properly except triggers. The trigger name was remapped correctly but the target table still referenced the old schema.

Failing sql is: CREATE TRIGGER "NEW_SCHEMA"."TRIGGER_NAME" BEFORE INSERT ON OLD_SCHEMA.TRIGGER_NAME ...

I'm surprised that something this obvious would go unfixed.

**note Multiple schema remaps are done as follows:

REMAP_SCHEMA=(OLD_SCHEMA1:NEW_SCHEMA1,OLD_SCHEMA2:NEW_SCHEMA2)