oracle导入导出 新建删除用户表空间
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