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