Skip to Main Content
Forums

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Disable trigger at a session level

NarendraPMay 23 2022

It would be useful if we are allowed to disable triggers only for current session. The presence of (enabled) triggers prevents a DML from running in parallel.
If we are allowed to disable trigger in a session, we can have batch jobs (like archival) that can benefit from having option to go parallel while allowing other transactional sessions to continue to operate with trigger functionality.
Disabling trigger at a session level can get recorded either in audit or in alert logs for traceability.

Comments

Sergey.N-Oracle

Hi Bruno!

Just to clarify: did you create new project or it is one was created with previous SDK version?

/Sergey

Bruno L

Hi Sergey!

It is the first time I have been using the ME SDK. I have created the project with version 8.

Bruno


Sergey.N-Oracle

Hi Bruno,

not sure but it looks like incorrect setup.  Could you try with latest SDK, Netbeans and Netbeans pluging?

/Sergey

Bruno L

Hi Sergey,

I use :

  • oracle-jmesdk-8-0-rr-win32-bin.exe
  • jdk-8u5-nb-8-windows-x64.exe
  • oracle-jmesdk-8-0-rr-nb-plugins.zip

I downloaded them on may 27th. I assume they are the latest packages.

Bruno

Sergey.N-Oracle

I've just verified with fresh installation: everything is OK.

1 - 5

Post Details

Added on May 23 2022
#active, #general-database-discussions-ideas, #trigger
2 comments
771 views