oracle删除用户下所有表、视图等操作（命令操作）

最新推荐文章于 2024-12-25 11:01:08 发布

风吹哪，哪就凉

最新推荐文章于 2024-12-25 11:01:08 发布

阅读量3.5k

点赞数

分类专栏：个人学习笔记文章标签： oracle删除用户下的表、视图等

本文链接：https://blog.csdn.net/weixin_39364310/article/details/86499649

版权

个人学习笔记专栏收录该内容

5 篇文章 0 订阅

订阅专栏

sqlplus;
–登录用户名与密码为需要删除的用户
SET HEAD OFF;
SPOOL e:/drop_tables.sql;
–delete tables
select ‘drop table ’ || table_name ||’;’||chr(13)||chr(10) from user_tables;
–delete views
select ‘drop view ’ || view_name||’;’||chr(13)||chr(10) from user_views;
–delete seqs
select ‘drop sequence ’ || sequence_name||’;’||chr(13)||chr(10) from user_sequences;
–delete functions
select ‘drop function ’ || object_name||’;’||chr(13)||chr(10) from user_objects where object_type=‘FUNCTION’;
–delete procedure
select ‘drop procedure ’ || object_name||’;’||chr(13)||chr(10) from user_objects where object_type=‘PROCEDURE’;
–delete package
select ‘drop package ’ || object_name||’;’||chr(13)||chr(10) from user_objects where object_type=‘PACKAGE’;
–delete trigger
SELECT ‘drop TRIGGER "’ ||SYS_CONTEXT(‘USERENV’,‘CURRENT_USER’)||’"."’|| TRIGGER_NAME ||’";’ ||CHR(13) ||CHR(10)FROM USER_TRIGGERS;
spool off;
@e:/drop_tables.sql;
purge recyclebin; --清空Oracle的回收站
quit --退出sqlplus