My Oracle Support Banner

How to Import Data Without Enabling Triggers (Doc ID 943834.1)

Last updated on AUGUST 04, 2018

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

To view full details, sign in with your My Oracle Support account.

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


In this Document
  Goal
  Solution

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.