drop user xx cascade; 删除用户
drop tablespace xxx including contents and datafiles;删除表空间
create tablespace np
datafile ‘D:\oracle\oracle11g\oradata\orcl\NP.dbf‘ size 500M
autoextend on
create user zc identified by "1"
default tablespace np;
grant dba to zc;
###################导入数据库####################（dmp路径可以直接拖动可以手动）
cmd 执行:
imp zc/1@orcl file=C:\Users\dll\Desktop\zc1224.dmp statistics=none full=y
###################导出数据库####################
exp zc/1@orcl file=C:\Users\dll\Desktop\zcnp1225.dmp
exp zc/1@192.168.1.3:1521/orcl file=E:\zc1224.dmp
原文：https://www.cnblogs.com/donglulu/p/12598405.html
如果您也喜欢它,动动您的小指点个赞吧
602392714
清零编程群