drop table tab1 purge;
create table tab1 (col1 char(1));
create or replace trigger tab1_trig
before insert on tab1
for each row
begin
null;
end;
/
show errors
select object_type from user_objects where object_name='TAB1_TRIG';
drop table tab1;
select object_type from user_objects where object_name='TAB1_TRIG';
that normally does the job for me