本文介绍了如何截断所有用户表?的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
如何截断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; /
更多推荐
如何截断所有用户表?
发布评论