--delete tables
--delete views
--delete seqs
--delete functions
--delete procedure
--delete package
- 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';
最省心的方法是级联删除
drop user USERNAME cascade; 最后这个级联特别有用(删除用户以及所有关联的数据库对象)
T:开发时我的做法是:(大写为可变)
1、在cmd中输入 - >sqlplus / as sysdba
或者用一个DBA的用户连接 sqlplus USERNAME/PASSWORD@//HOST:PORT/SERVICE_NAME
2、删除用户A,级所有和用户A关联的数据 - >drop user A cascade;
3、重建用户A - >create user A identified by PASSWORD;
4、赋权用户 - >grant connect,resource to A;
S:没有安装sqlplus可以去看这个大神的文章: http://blog.csdn.net/z69183787/article/details/22690123
S:想了解更多的sqlplus命令请转到这里:
http://www.jb51.net/article/40280.htm