How to Import Data Without Enabling Triggers

(Doc ID 943834.1)

Last updated on NOVEMBER 28, 2016

Applies to:

Oracle Server - Enterprise Edition - Version: 10.2.0.1
Information in this document applies to any platform.

Goal

You are trying to import data from an export.dmp file (old export utility), but the triggers in the export.dmp file keep firing and you do not want that to happen.  You cannot export the data again without triggers because the database has been deleted.

You have tried to prevent the triggers from being enabled/fire on Import by revoking, CREATE TRIGGER, CREATE ANY TRIGGER, CREATE PROCEDURE, and CREATE ANY PROCEDURE from the User performing the import, but triggers keep getting enabled at the end of the import.

Solution

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