IMPDP - ORA-39083 and ORA-04072 Invalid Trigger Type (Doc ID 1567015.1)

Last updated on NOVEMBER 28, 2016

Applies to:

Oracle Database - Enterprise Edition - Version 11.2.0.3 and later
Information in this document applies to any platform.

Symptoms

When attempting to run an Import Data Pump job the following error occurs.

Import: Release 11.2.0.3.0 - Production on Thu Jun 27 07:41:32 2013

...
Processing object type SCHEMA_EXPORT/EVENT/TRIGGER
ORA-39083: Object type TRIGGER failed to create with error:
ORA-04072: invalid trigger type
Failing sql is:
BEGIN DBMS_DDL.SET_TRIGGER_FIRING_PROPERTY('"AGILE932DEV02"','"SWAPOPTIMIZER"',FALSE) ; END;
Processing object type SCHEMA_EXPORT/TABLE/INDEX/FUNCTIONAL_AND_BITMAP/INDEX
...

 

Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms