1、创建一个删除的脚本
set heading off
set feedback off
set pagesize 0
spool c:1.sql
select 'drop table '||table_name|| ';' from user_tables;
select 'drop view '||view_name|| ';' from user_views;
select 'drop sequence '||sequence_name|| ';' from user_sequences;
select 'drop function '||object_name|| ';' from user_objects where object_type='FUNCTION';
select 'drop procedure '||object_name|| ';' from user_objects where object_type='PROCEDURE';
select 'drop package '||object_name|| ';' from user_objects where object_type='package';
select 'drop database link '||object_name|| ';' from user_objects where object_type='DATABASE LINK';
spool off;
set heading on;
set feedback on;
2、执行脚本
sql>@1.sql
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/309902/viewspace-1048609/ ，如需转载，请注明出处，否则将追究法律责任。
