DataPump Import Of Event Trigger Reports Errors ORA-39083, ORA-4072
Last updated on NOVEMBER 28, 2016
Applies to:Oracle Database - Enterprise Edition - Version 22.214.171.124 to 126.96.36.199 [Release 11.2]
Information in this document applies to any platform.
***Checked for relevance on 04-Aug-2014***
- While importing a logon trigger with DataPump Import (impdp) the following errors are reported:
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:
,FALSE) ; END;
Job "SYSTEM"."SYS_IMPORT_SCHEMA_01" completed with 1 error(s) at 15:21:34
- Despite of the above error message, the trigger was created successfully.
column owner format a20
column trigger_name format a20
from dba_triggers where owner='TEST';
select status from dba_objects
where owner='TEST' and object_name='TRG_LGON';
Permanently reproducible on 188.8.131.52
Issue does not occur with 10g and 11g Release 1.
None. - The affected trigger is imported successfully.
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