Can I use 'truncate table ..' on a system trigger?
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.
Re: Can I use 'truncate table ..' on a system trigger?
Quote:
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