DataPump Import Of Event Trigger Reports Errors ORA-39083, ORA-4072 (Doc ID 1143185.1)

Last updated on NOVEMBER 28, 2016

Applies to:

Oracle Database - Enterprise Edition - Version 11.2.0.1 to 11.2.0.3 [Release 11.2]
Information in this document applies to any platform.
***Checked for relevance on 04-Aug-2014***

Symptoms

IMPDP LOGFILE
-------------
...
Processing object type SCHEMA_EXPORT/PRE_SCHEMA/PROCACT_SCHEMA
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('"TEST"','"TRG_LGON"'
,FALSE) ; END;

Job "SYSTEM"."SYS_IMPORT_SCHEMA_01" completed with 1 error(s) at 15:21:34

 

column owner format a20
column trigger_name format a20
select OWNER,TRIGGER_NAME
from dba_triggers where owner='TEST';

OWNER                TRIGGER_NAME
-------------------- --------------------
TEST                 TRG_LGON


select status from dba_objects
where owner='TEST' and object_name='TRG_LGON';

STATUS
-------
VALID


Reproducibility
Permanently reproducible on 11.2.0.1
Issue does not occur with 10g and 11g Release 1.

Impact
None. - The affected trigger is imported successfully.

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