1.以system用户登录
2.创建用户
create user sdzg identified by sdzg;
3.创建表空间
create tablespace sdzg_space datafile ‘D:\sdzg\sdzg.dbf’ size 4000M;
4.指定用户使用的表空间
alter user sdzg default tablespace sdzg_space;
5.给用户授权
grant create session,create table,create view,create sequence,unlimited tablespace to sdzg;
6.导入imp
sdzg/sdzg@localhost:1521/orcl file=D:\sdzg\daochu.dmp log=D:\sdzg\daochu.log full=y;