drop user XXXX cascade;
drop tablespace XXXX INCLUDING CONTENTS;
--------------------------------------
SQLPLUS登陆到用户A,执行下面的脚本。
SET PAGESIZE 0
spool c:/dropobj.sql
SELECT 'DROP ' || object_type || ' ' || object_name || ';'
FROM user_objects
WHERE object_type IN ('PROCEDURE', 'FUNCTION', 'SEQUENCE', 'VIEW', 'PACKAGE', 'SYNONYM');
spool off
spool c:/droptab.sql
SELECT 'DROP TABLE "' || object_name || '" CASCADE CONSTRAINTS PURGE;'
FROM user_objects
WHERE object_type = 'TABLE';
spool off
在C:/找到dropobj.sql和droptab.sql,
用记事本打开,编辑一下,在sqlplus下执行这两个脚本。
如果是oracle10g,drop table前还要加上这句
alter session set recyclebin=off;