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;