创建空间
CREATE TABLESPACE GUOFENG001
DATAFILE 'D:/GUOFENG001/GUOFENG001.DBF'size 1024m
AUTOEXTEND ON next 50m
修改用户默认的表空间
ALTER USER system IDENTIFIED BY system DEFAULT TABLESPACE GaUOFENG003;
创建用户为这个用户指定一个空间
create user guofeng003 identified by guofeng003 default tablespace guofeng003;
授权
grant dba to guofeng003
执行导入命令
imp guofeng003/guofeng003 fromuser=guofeng003 touser=,guofeng003 IGNORE=y FILE=d://guofeng003.dmp