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