ORACLE数据泵备份还原数据库

备份
把排除的几张表，自己再加上去

expdp user1/123456 directory=DATA_PUMP_DIR dumpfile=201609cDB.dmp logfile=201609cDB.log schemas=cbms EXCLUDE=TABLE:\" IN ('PUB_OT','D_LOG','K_LOG','H_LOG')\"

还原

IMPDP USERID='user2/111111@orcleb as sysdba' directory=DATA_PUMP_DIR dumpfile=201609cDB.dmp.DMP logfile=201609cDB.dmp.log remap_schema=user1:user2

查找导出目录

select * from dba_directories t;

新建用户

create tablespace c_jiash 
datafile 'D:/jiashDbk/c_data.dbf' size 1M 
autoextend on 
next 2M 
maxsize unlimited; 

create user cJiash IDENTIFIED BY 111111;

grant connect,resource to cJiash