Re: Constraint violation in spite of trigger with sequence

  • From: Jared Still <jkstill@xxxxxxxxx>
  • To: Adam Musch <ahmusch@xxxxxxxxx>
  • Date: Tue, 2 Feb 2010 09:49:28 -0800

On Tue, Feb 2, 2010 at 9:29 AM, Adam Musch <ahmusch@xxxxxxxxx> wrote:

> The only ways I know of to avoid a trigger is:
>
> 1.  Disable it.
> 2.  Use SQL*Loader in direct mode, which will write blocks directly,
> bypassing triggers.
>
>
There are other ways to disable a trigger, which is why I asked to see
the code.  Back to productive work now.


Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist
Oracle Blog: http://jkstill.blogspot.com
Home Page: http://jaredstill.com

Other related posts: