简介:Oracle删除某个用户下的所有对象,执行需谨慎在PL/sql中,点”新建”-“命令窗口”-粘贴后直接执行–删除某个用户下的对象setheadingoffsetFeedbackoffspoold:/dropobj.sqlprompt–Dropconstraintselect‘altertable‘||table_n。
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.sqlhost del d:/dropobj.sql
总结
以上是为你收集整理的Oracle 删除某个用户下的所有对象,执行需谨慎全部内容,希望文章能够帮你解决Oracle 删除某个用户下的所有对象,执行需谨慎所遇到的程序开发问题。