Deprecated: Unparenthesized `a ? b : c ? d : e` is deprecated. Use either `(a ? b : c) ? d : e` or `a ? b : (c ? d : e)` in /home/sgreimer/stevenreimer.com/includes/utilities/library.php on line 660

Deprecated: Unparenthesized `a ? b : c ? d : e` is deprecated. Use either `(a ? b : c) ? d : e` or `a ? b : (c ? d : e)` in /home/sgreimer/stevenreimer.com/includes/Page.class.php on line 574
StevenReimer.com :: Home

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)