ORCALE导入的dmp文件

1.创建表空间DATA

CREATE TABLESPACE DATA LOGGING DATAFILE ‘E:\folder\xxx.DBF’ SIZE 32M AUTOEXTEND ON NEXT 32M MAXSIZE UNLIMITED EXTENT MANAGEMENT LOCAL;

2.创建表空间DATAXXX

CREATE TABLESPACE DATAXXX LOGGING DATAFILE ‘E:\folder\yyy.DBF’ SIZE 32M AUTOEXTEND ON NEXT 32M MAXSIZE UNLIMITED EXTENT MANAGEMENT LOCAL;

3.删除用户，创建用户

drop user 用户名 cascade;
create user 用户名 identified by 密码;

4.用户授权

grant resource,dba,connect to 用户名;

5.导入数据库

imp “user/pwd”@127.0.0.1:1521/orcl file=E:\路径\xxxx.dmp ignore=true fromuser=uesrA touser=userB log=E:\dolser\xxxx.log