Oracle 删除某个用户下的所有对象,执行需谨慎
在PL/sql中,点"新建"->"命令窗口"->粘贴后直接执行
--删除某个用户下的对象 set heading off; set feedback off; spool d:/dropobj.sql; prompt --Drop constraint select ‘alter table ‘||table_name||‘ drop constraint ‘||constraint_name||‘ ;‘ from user_constraints where constraint_type=‘R‘; prompt --Drop tables select ‘drop table ‘||table_name ||‘;‘ from user_tables;
prompt --Drop view select ‘drop view ‘ ||view_name||‘;‘ from user_views;
prompt --Drop sequence select ‘drop sequence ‘ ||sequence_name||‘;‘ from user_sequences;
prompt --Drop function select ‘drop function ‘ ||object_name||‘;‘ from user_objects where object_type=‘FUNCTION‘;
prompt --Drop procedure select ‘drop procedure ‘||object_name||‘;‘ from user_objects where object_type=‘PROCEDURE‘;
prompt --Drop package prompt --Drop package body select ‘drop package ‘|| object_name||‘;‘ from user_objects where object_type=‘PACKAGE‘;
prompt --Drop database link select ‘drop database link ‘|| object_name||‘;‘ from user_objects where object_type=‘DATABASE LINK‘;
spool off; set heading on; set feedback on;
@@d:/dropobj.sql;host del d:/dropobj.sql;
(编辑:李大同)
【声明】本站内容均来自网络,其相关言论仅代表作者个人观点,不代表本站立场。若无意侵犯到您的权利,请及时与联系站长删除相关内容!
|