Oracle Data Pump Import issue
11 September 2013
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)
Tags
motorcycle (8) cars (4) work (11) web development (7) porsche (2) life (26) holidays (1) new year (1) photography (3) travel (3) london (1) ubuntu (12) linux (21) birthday (2) weather (1) bow island (2) parenthood (1) qos (1) firewall (1) css (3) fire (1) diy (3) laptop (2) chart (1) test (2) cooling (1) politics (2) harper (1) media (1) modx (1) development (18) pie (1) microsoft (3) sharepoint (1) wine (1) video editor (1) canada (1) abby (1) wii (1) parenting (3) shoelaces (1) christmas (1) pictures (2) unix (1) time (1) google (2) picasa (1) windows (2) joel (1) twitter (1) technology (1) deadline (1) triumph (3) tiger (1) holiday (1) apache (1) mysql (10) tip (1) mechanics (1) server (1) smartphone (1) android (7) vm (1) ted (1) music (1) sql (1) postgres (1) svn (1) vmware (1) house (2) camping (1) replication (2) mechanic (1) oracle (2) databases (1) debian (1) sqlserver (1) sql server (1) datapump (1) blog (1) C# (1) MVC (1)