Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Modify trigger - Look

Re: Modify trigger - Look

From: DA Morgan <damorgan_at_psoug.org>
Date: Mon, 16 Jul 2007 06:56:39 -0700
Message-ID: <1184594198.954703@bubbleator.drizzle.com>


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.org
Received on Mon Jul 16 2007 - 08:56:39 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US