SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Unable to drop trigger

588400May 13 2008 — edited May 13 2008

Hi everyone.

I created a trigger with user "jasont" in oracle called "insert_primary". Now when I try to drop the trigger by using the following command:

drop trigger jasont.insert_primary;

I get the error ORA04080 - Trigger "insert_primary" does not exist.

This is very strange because jasont is the owner of the trigger. I confirmed that by checking in ALL_OBJECTS.

I have tried using SQLPLUS/SQL Developer. Nothing is dropping it.

Any suggestions. I cannot use sys.

Thanks

Locked Post

New comments cannot be posted to this locked post.

Locked on Jun 10 2008

Added on May 13 2008

2 comments

869 views