oracle 11g数据库 DMP还原数据库
--------------------------
jd :表空间 注意:表空间和要和还原表空间一致
--------------------------
--本地登陆 cmd下直接执行
sqlplus/as sysdba;
--修改密码
alter user system identified by 123456;
----创建表空间
create tablespace jd
logging
datafile 'D:\Oracle\data\jd.ora' size 100M reuse
extent management local segment space management auto;
----创建用户
create user jduser
identified by "jduser"
default tablespace jd
temporary tablespace temp
profile default
quota unlimited on jd;
---授权
grant connect to jduser;
grant exp_full_database to jduser;
grant imp_full_database to jduser;
grant connect,resource,dba to jduser;
--并给用户解锁
alter user jduser account unlock;
--创建expdir
create or replace directory expdir as 'D:/';
--还原数据库 cmd下直接执行
impdp jduser/jduser directory=expdir dumpfile=JDGS_20170925_123127.DMP