如何截断所有用户表?

本文介绍了如何截断所有用户表?的处理方法，对大家解决问题具有一定的参考价值，需要的朋友们下面随着小编来一起学习吧！ 问题描述

如何截断oracle中的所有用户表?我对表约束有疑问.

How can I truncate all user table in oracle? I have problem with tables constraints.

推荐答案

declare begin for c1 in (select table_name, constraint_name from user_constraints) loop begin execute immediate ('alter table '||c1.table_name||' disable constraint '||c1.constraint_name); end; end loop; for t1 in (select table_name from user_tables) loop begin execute immediate ('truncate table '||t1.table_name); end; end loop; for c2 in (select table_name, constraint_name from user_constraints) loop begin execute immediate ('alter table '||c2.table_name||' enable constraint '||c2.constraint_name); end; end loop; end; /