-
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?
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
J Gangadhar
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|