Oracle数据库最小脚本

 删除表空间SQL

DROP TABLESPACE 表空间名
    INCLUDING CONTENTS  AND DATAFILES
      CASCADE CONSTRAINTS 

删除用户及数据

 drop user 用户名 cascade

--创建表空间

create tablespace V6USER datafile '&1\V6USER.dbf' size 100m autoextend on next 10m;

--创建用户

create user V6USER identified by cape default tablespace V6USER;

--赋权

grant dba to V6USER;

导入dmp文件

imp V6USER/cape@XXXX file=d:\XXXX.dmp fromuser=V6USER_formal touser=V6USER

--删除表空间

drop user V6USER cascade;
drop tablespace V6USER including contents and datafiles;