1、删除数据库用户→然后创建用户→赋权限→还原数据库
drop user userName cascade;
create user userName identified by password default tablespace tablespaceName temporary tablespace temp;
grant connect,resource,dba to userName;
impdp userName/userName@orcl SCHEMAS=userName DIRECTORY=password DUMPFILE=dataName.DMP LOGFILE=logName.log
userName:数据库用户名
password:数据库用户密码
tablespaceName:表空间(没有先要建表空间)
temp:临时表空间(没有先要创建)
dataName.DMP:还原的数据库文件
logName.log:日志文件
2、创建表空间
/*创建临时表空间 */
create temporary tablespace temp
tempfile 'D:\oracle\oradata\Oracle9i\temp.dbf'
size 50m
autoextend on
next 50m maxsize 20480m
extent management local;
create temporary tablespace temp_01 tempfile 'D:\temp_01.dbf' size 1024m autoextend on next 1024m;
/*创建数据表空间 */
create tablespace tablespaceName
logging
datafile 'D:\oracle\oradata\Oracle9i\data.dbf'
size 50m
autoextend on
next 50m maxsize 20480m
extent management local;
create tablespace data_01 tempfile 'D:\data_01.dbf' size 1024m autoextend on next 1024m;