Re: -- Alter trigger not working in script
Date: 26 Mar 2003 22:57:56 -0800
Message-ID: <4d32d1be.0303262257.5af0ba87_at_posting.google.com>
Mark.Powell_at_eds.com (Mark D Powell) wrote in message news:<2687bb95.0303261717.3a2b93f_at_posting.google.com>...
> avanrossem_at_hotmail.com (Andre) wrote in message news:<4d32d1be.0303260447.7316a97c@posting.google.com>...
> > Hello all,
> >
> > I have a sql-script in which some triggers has to be disabled first to
> > proceed.
> > In sqlPlus I do NOT see that the triggers are disabled.
> > I suspect a "Trigger altered." statement.
> > Also the sql-script doesn't work because the triggers are NOT
> > disabled.
> > When I try the script on another machine everything is working. (I do
> > see the "Trigger altered." statement)
> >
> > Here are the first two lines of the script:
> >
> > alter trigger IU_a disable;
> > alter trigger IU_B disable;
> >
> > What can be the problem???
> >
> > Thanks for all suggestions, and kind regards,
> > Andre
>
> Andre, were you the owner when you ran the script that failed? How
> about when you ran the one that worked?
>
> It would have been nice to see actual script output or error messages
> rather than just hazard a guess you are not the trigger owner and have
> to qualify the statements.
>
> HTH -- Mark D Powell --
Well,
On both systems i logged onto the databse with the same user_id and password. on one system the sql-script doesn't work, on the other it did! Thx! Received on Thu Mar 27 2003 - 07:57:56 CET