My Oracle Support Banner

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

Last updated on SEPTEMBER 19, 2019

Applies to:

Oracle Database - Enterprise Edition - Version 10.2.0.1 and later
Oracle Database Cloud Schema Service - Version N/A and later
Oracle Database Exadata Cloud Machine - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Oracle Database Cloud Exadata Service - Version N/A and later
Information in this document applies to any platform.
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.