Database Utilities (MOSC)

MOSC Banner

How avoid a trigger to be fired during a IMPdp Session performed by another user?

Running Oracle 19c under Linux, an Exa8 env RAC 2 nodes. It´s a business critical mission Database with high workloads in batches, as well as OLTP connecting hundreds of users. The schema OWNER1 has a table named TABLE01; there is a (INSERT triggering Event) trigger named TRIGGER01 attached. Another user called USER01 needs to perform a massive IMPdp DataPump to restore a huge data mass volume. How avoid the OWNER1.TRIGGER01 (INSERT_EVENT) to be fired during an IMPdp DataPump Session performed by USER01, without editing the pl-sql code?

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center