impdp/expdp导入导出库

导出数据库

删除用户  drop user zwzhang  cascade;
创建指定导出路径；
create or replace directory dmpdir as '/oraexport/dmpdir/';

给xiaoyao用户赋予权限
grant read,write on directory dmpdir to xiaoyao;
导出数据库
expdp xiaoyao/xiaoyao directory=dmpdir dumpfile=expxiaoyao.dmp logfile=exp.log  schemas=xiaoyao

导入数据库：

创建用户 impXiaoyao
create user impXiaoyao identified by impXiaoyao default tablespace itreasury temporary tablespace temp account unlock;

给impXiaoyao赋予权限
grant connect, resource, dba to impXiaoyao;

创建导入 指定路径
create or replace directory dmpdir as '/home/';
赋予权限
grant read,write on directory dmpdir to impXiaoyao;

导入数据
impdp impXiaoyao/impXiaoyao remap_schema=xiaoyao:impXiaoyao  directory=dmpdir dumpfile=expxiaoyao.dmp  table_exists_action=replace logfile=xiaoyao_impdp_replace.log status=30

空表也导入

impdp impXiaoyao/impXiaoyao remap_schema=gdfcl:impXiaoyao directory=dmpdir dumpfile=expxiaoyao.dmp table_exists_action=replace logfile=xiaoyao_impdp_replace.logtransform=segment_attributes:n status=30

导入单张表：
impdp impXiaoyao/impXiaoyao remap_schema=xiaoyao:impXiaoyao directory=dmpdir dumpfile=expxiaoyao.dmp tables=xiaoyao.xxx  table_exists_action=replace  logfile=xiaoyao_impdp_replace.log