|
-
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.
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
|