oracle删除用户及表空间，导入用户和数据

drop user xxx cascade;
drop tablespace xxx including contents and datafiles;
create tablespace xxx datafile ‘E:\oracle\product\10.2.0\oradata\ts\xxx.dbf‘ size 100M  autoextend on next 10m  maxsize unlimited;
create user xxx identified by "ppp" default tablespace xxx temporary tablespace temp profile default;
grant connect,resource to xxx;
imp xxx/ppp@orcl file=d:\zzz.dmp fromuser=xxx touser=xxx
imp xxx/ppp@orcl file=d:\zzz.dmp full=y

oracle删除用户及表空间，导入用户和数据

标签：