How to delete a Trigger?

I create some Triggers like the following for example:

CREATE OR REPLACE TRIGGER TRIGGER_USER
BEFORE INSERT ON HOUSE_USER
REFERENCING OLD AS OLD NEW AS NEW
FOR EACH ROW
    WHEN (NEW.USER_ID IS NULL)
BEGIN
    SELECT SEQ_USER_ID.NEXTVAL
    INTO :NEW.USER_ID FROM DUAL;
END;
/

But i cant drop them. When i try to drop it:

DROP TRIGGER TRIGGER_USER;

I get the following error:

ORA-04080: trigger 'TRIGGER_USER' does not exist

I found out that you have to tell the schema. I fired the following Command:

SELECT * FROM ALL_TRIGGERS WHERE TABLE_NAME = 'HOUSE_USER'

It Delivered:

OWNER: APEX
TRIGGER_NAME: TRIGGER_USER

So i tried again with:

DROP TRIGGER APEX.TRIGGER_USER;

But i again got the error:

ORA-04080: trigger 'TRIGGER_USER' does not exist

So: how can i delete triggers?


Source: oracle

Leave a Reply