Re: Modify trigger - Look

On Jul 16, 3:37 am, Alex Bibiano <a..._at_bibiano.es> 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.

You can't see fit to report which release of Oracle you're using, so who could tell you what is actually 'wrong' with this process.

Provide the full version of Oracle (all four numbers) AND the exact error message reported to you. Maybe then someone can provide some usable assistance.

David Fitzjarrell Received on Mon Jul 16 2007 - 08:44:03 CDT