Oracle Data Pump

Oracle Data Pump

概念

只能用于服务器端

表、方案、表空间、整个数据库

工具集介绍

impdp -help
expdb -help

目录对象

dba
!mkdir dump

create directory dump_dir as '/home/oracle/dump';
grant read, write on directory dump_dir to system;
select * from dba_directories where DIRECTORY_NAME='DUMP_DIR';

表

$ expdp system/oracle directory=dump_dir dumpfile=dumptable.dmp tabels=regions, jobs logfile=dumptable.log

用户

$ expdp system/oracle directory=dump_dir dumpfile=dumpschema.dmp schemas=hr logfile=dumpschema.log

表空间

$ expdp system/oracle directory=dump_dir dumpfile=dumptablespace.dump tablespaces=users logfile=dumptablespace.log

整个库

$ expdp system/oracle directory=dump_dir dumpfile=dumpfull.dump full=Y logfile=dumpfull.log

并行度

parallel = 4 

dumpfull=dumpfill%U.dump

学习链接

• Oracle Data Pump