sqlplus / as sysdba;
3、创建表空间
create tablespace XD_DATA(表空间名) datafile 'E:\Oracle\XD_DATA' size 1000M extent management local segment space management auto;
create user userName identified by userPassWord default tablespaceXD_DATA;
grant dba to userName;
5、将数据导入表空间
imp userName/UserPassWord@localhost:1521/orcl file E:\data\20170705.dmp full=y;