oracle 数据库导入

创建空间

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