ORACLE清空某用户下所有表记录truncate

　　declare　　towner varchar2(30);　　begin　　towner := '&user';　　/*　　先禁用表上所有的外键约束　　*/　　for c in (select 'alter table '||owner||'.'||t.table_name || ' disable CONSTRAINT '||t.constraint_name as csql from all_constraints