Truncate multiple tables script
I'm having a problem with a truncate script. I want to truncate all tables owned by 'PERFSTAT' (This is a test I want to run before the real thing).
select 'truncate table ' || owner || '.' || table_name || ' cascade constraints; '
where owner in ('PERFSTAT')
IF A RUN A SIMPLE SELECT STATEMENT AFTER THIS EXECUTION, NOTHING WAS TRUNCATED
NB:this script was previously used for 'drop table' with success.
Click Here to Expand Forum to Full Width