Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: Modify trigger - Look
Alex Bibiano wrote:
> My problem is that I can't drop/disable/replace the trigger. I have
> restart the database and the server.
>
> I have done the same replace script in my test database without
> problems.
>
> select * from V$LOCKED_OBJECT returns no rows.
>
>
> --
> I have also a view impossible to delete o modify.
>
> Thanks
>
> Alex B.
Posting the version, error messages and DDL would help.
-- Daniel A. Morgan University of Washington damorgan_at_x.washington.edu (replace x with u to respond) Puget Sound Oracle Users Group www.psoug.orgReceived on Mon Jul 16 2007 - 08:56:39 CDT
![]() |
![]() |