数据泵备份还原

作者: zdz_peng | 来源:发表于2019-01-02 16:46 被阅读0次

# 创建表空间
CREATE TABLESPACE monitor
LOGGING
DATAFILE 'C:\app\Administrator\oradata\orcl\monitor.dbf'
SIZE 32M
AUTOEXTEND ON
NEXT 32M MAXSIZE UNLIMITED
EXTENT MANAGEMENT LOCAL;

# 创建用户，指定表空间
CREATE USER monitor IDENTIFIED BY monitor
         ACCOUNT UNLOCK
         DEFAULT TABLESPACE monitor;

# 给用户赋权限
GRANT CONNECT,RESOURCE TO  monitor;
GRANT DBA TO monitor;

# 给用户操作目录的权限
grant read,write on directory dpump to monitor;

expdp monitor/pass@orcl schemas=monitor dumpfile=monitor20181229.dmp directory=dpump logfile=monitor20181229.log  version=11.1.0.6.0  --content=METADATA_ONLY

impdp monitor/monitor@127.0.0.1/orcl directory=dpump remap_schema=monitor:monitor remap_tablespace=monitor:monitor dumpfile=MONITOR20181229.DMP