Can I use 'truncate table ..' on a system trigger?

[ssmith]

I want to truncate a working table after a database startup? Can I use the system trigger 'after startup of database' to do this?
e.g.
create or replace trigger dbstartup
after startup on database
begin
execute immediate 'truncate table testuser.output_table;';
end;
Thanks.

[marist89]

Sure, why not?

[ganga]

Originally posted by ssmith
I want to truncate a working table after a database startup? Can I use the system trigger 'after startup of database' to do this?
e.g.
create or replace trigger dbstartup
after startup on database
begin
execute immediate 'truncate table testuser.output_table;';
end;
Thanks.

Hi man
i tried this
the trigger get created but i didnot work